Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I am looking for a way to display the correct year according to a calendar week (cw) based on a date.
Solution has to be ISO 8601 conform.
Current Script:
week(myDate) & ' / ' & year(myDate)
Example:
01. Jan 2008 --> 01/2008 --> correct
01. Jan 2010 --> 52/2010 --> wrong! should be 52/2009!
31. Dec 2007 --> 01/2007 --> wrong! should be 01/2008!
Any ideas / hints how to solve this?
Many thanks in advance
Hi qv..
Try this:
New Script:
week(myDate) & '/' & weekYear(myDate)
hth/gg
Hi qv..
Try this:
New Script:
week(myDate) & '/' & weekYear(myDate)
hth/gg
Hi,
I think you have to use
week(myDate) & '/' & YearEnd(myDate)
HTH
Regards
Anand
Hi gg,
this is awesome...
It costs me half a day to try it by my own and 6 minutes to figure out that it was directly in front of me the whole time!
many thanks!