Forum Discussion
Need Help Date Table
I have a date column where I want to divide dates into periods from 01st April and further by Week numbers in each period. Any ideas?
v-xiaotang - Sorry, only saw your message today.
Theer are 13 periods in total in a year.
P01 starts in April and P13 ends in March.
P02 - P12 are all 28 days (4 weeks).
I would imagine P01 and P13 balances the rest (?) - Total 53 weeks.
XX13 is last period of Year and XX01 is the first period.
XX02 to XX12 - Each 4 week periods
Does this help?