Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following in the script to align the dates to the Fiscal Year July - June.
if(Month(Date([SAL_InvoiceDate] + MakeDate(2000,1,1))) > 6, Year(Date([SAL_InvoiceDate] + MakeDate(2000,1,1)))+1, Year(Date([SAL_InvoiceDate] + MakeDate(2000,1,1)))) as FiscalYear,
dual(month(Date([SAL_InvoiceDate] + MakeDate(2000,1,1))),month(addmonths(Date([SAL_InvoiceDate] + MakeDate(2000,1,1)),6))) as FiscalMonth,
Week(Date([SAL_InvoiceDate] + MakeDate(2000,1,1))) as Week;
Currently, the above expression for the week shows the week is aligned to the calendar year. I need an additional expression for the week to be aligned to the fiscal year.
Any ideas?
Thanks
Shamit
Have you tried playing around with the scrip provided by jagan
The script is working fine as far as the months and quarters are concerned.
I wanted to bring in the weeks and align them to the fiscal year i.e. July - June
I included the following,but still having issues in that the week start's on Monday as opposed to Sunday:
Set vCal_FD = 6; // First Day of the week (0=Mon, 1=Tue, ... , 6=Sun)
WeekStart(Date ([PKL_PickedDate]+ MakeDate(2000,1,1)), 6, $(vCal_FD))as WeekStart,
dual(WeekStart(Date([PKL_PickedDate] + MakeDate(2000,1,1))),WeekStart(AddMonths(Date([PKL_PickedDate] + MakeDate(2000,1,1)),6))) as PickedFiscalWeek;
Thanks
Shamit