How to create Week number starting from Jun 2018

[Gowtham174]

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

[sibin_jacob]

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;

[renuka_sasikumar]

Hi,

You can try this, Hope this help

Regards,

Renuka S