Hi All,
Can you help me to create a fiscal calendar for
29-06-2018 to 05-07-2018 -start Week (Week 1)
.
.
.
.
27-06-2019 to 27-06-2019 - end Week (Week 52)
Also i need to change the Year accordingly. I tried with below and week number got changed accordingly. I Stuck with year how to change the year
Right(WeekName(REPORT_DATE,-25,4),2) as WeekNumber,
Thanks,
Gowtham