Viewing 8 posts - 1 through 8 (of 8 total)
The script is for a dashboard. I can't see it having a lifespan longer than 2 years. As regards the number of weeks, for me the key phrase in your...
February 10, 2021 at 9:10 am
Monday to Sunday would be good for me to consider a week. It would be great to see the first week of 2021 as week 1 with just one working...
February 9, 2021 at 4:44 pm
If I try to use iso_week, I get the following 'amazing' results:
20201225 2020_52
20201228 2020_53
20201229 2020_53
20201230 2020_53
20201231 2020_53
20210101 2021_53
20210104 2021_1
20210105 2021_1
20210106 2021_1
20210107 2021_1
20210108 2021_1
20210111 2021_2
20210112 2021_2
20210113 2021_2
20210114 2021_2
20210115 2021_2
20210118 2021_3
20210119 2021_3
20210120...
February 9, 2021 at 4:07 pm
iso_week has worked wonderfully, thank you! I am going to use this in the future. Having iso-week, I don't see the point of week, to be honest.
February 5, 2021 at 9:00 am
This is the solution I finally went with. I'll be honest, there is a bit of cut-and-paste from Stackoverflow, which I don't entirely understand, but it is working fine.
January 8, 2021 at 10:38 am
Is WW the week number - or month number? If week number - is it ISO week or US week?
It's a calendar week number, as in the first week...
January 8, 2021 at 9:35 am
If StartDate was 2018-12-31 and SessionDate was 2020_01, what would be your desired answer as the number of years between the two?
So, 2018-12-31 to 2020-01 is not full 2...
January 7, 2021 at 4:43 pm
Yes, I do want to take the month into consideration.
January 7, 2021 at 4:31 pm
Viewing 8 posts - 1 through 8 (of 8 total)