Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please help me to create fiscal week number staring from Jun 2018
29-06-2018 to 05-07-2018 -start Week (Week 1)
.
.
.
.
27-06-2019 to 27-06-2019 - end Week (Week 52)
Thanks,
Gowtham
Please use the below script,
I have added only for few dates.
test:
load * inline [
Date_value
29-06-2018
30-06-2018
01-07-2018
02-07-2018
03-07-2018
04-07-2018
05-07-2018
06-07-2018
07-07-2018
08-07-2018
09-07-2018
10-07-2018
11-07-2018
12-07-2018
13-07-2018
14-07-2018
15-07-2018
16-07-2018
];
test1:
Load Date_value, 'Week ' & (floor((RowNo()/7)-.01)+1) as Week_Number
Resident test;
Drop table test;
Hi,
You can try this, Hope this help
Regards,
Renuka S