Week number

Recommended Posts

Hello all.

Is there a way to get the current week number (1 ... 52/53)  of the year ?

Thanks

Share on other sites

• MVP 2023

Standard formula from Wiki need  Year, Day of Year, Day of Week for calculation.

Day of Year sample

SI33 and SI34 can be used.

Share on other sites

Never had such a request, so I did it as an exercise. As suggested in topic @kratmel posted when dealing with time intervals it's best to use RTC to UTC functions, so you manipulate only with one DW variable. That's also my experience.

• 1
Share on other sites

10 hours ago, Isakovic said:

Never had such a request, so I did it as an exercise. As suggested in topic @kratmel posted when dealing with time intervals it's best to use RTC to UTC functions, so you manipulate only with one DW variable. That's also my experience.

I cannot download your file.  Browser reports it as dangerous file.  May you upload it again zipped?

Maybe now.

Share on other sites

Thanks Isakovic, I will test it

Share on other sites

• 1 year later...
On 9/8/2021 at 6:33 AM, Isakovic said:

Peut-être maintenant.

Bonjour, c'est possible d'avoir votre fichier ? je suis dans le même cas.  mais pour un v120 et en affichage automatique.

Hello, is it possible to have your file? I am in the same situation. but for a v120 and in automatic display.

Share on other sites

Here is the file.

I downloaded it from my post, don't know why it doesn't work for you.

Share on other sites

Merci, en fait c’est pour un V120 donc le problème c’est que les valeurs maximales du MI et du DUnS#, ne sont pas les mêmes . Puisque je suis novice, c’est compliqué pour moi. Merci quand même.

Thank you, in fact it is for a V120 so the problem is that the maximum values of the MI and DUnS#, are not the mSince. I'm a novice, it's complicated for me. Thank you anyway.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

×