Gabriel Franco Posted September 5, 2021 Report Share Posted September 5, 2021 Hello all. Is there a way to get the current week number (1 ... 52/53) of the year ? Thanks Quote Link to comment Share on other sites More sharing options...
MVP 2021 kratmel Posted September 5, 2021 MVP 2021 Report Share Posted September 5, 2021 Standard formula from Wiki need Year, Day of Year, Day of Week for calculation. Day of Year sample SI33 and SI34 can be used. Quote Link to comment Share on other sites More sharing options...
Isakovic Posted September 7, 2021 Report Share Posted September 7, 2021 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. Sedmica.vlp 1 Quote Link to comment Share on other sites More sharing options...
Gabriel Franco Posted September 7, 2021 Author Report Share Posted September 7, 2021 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. Sedmica.vlp 919.94 kB · 10 downloads I cannot download your file. Browser reports it as dangerous file. May you upload it again zipped? Quote Link to comment Share on other sites More sharing options...
Isakovic Posted September 8, 2021 Report Share Posted September 8, 2021 Maybe now. Sedmica.zip Quote Link to comment Share on other sites More sharing options...
Gabriel Franco Posted September 8, 2021 Author Report Share Posted September 8, 2021 Thanks Isakovic, I will test it Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.