Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was wondering if anyone knew how I can change Week(Date) to be the fiscal week number rather than calendar year week number.
Thanks,
Darren
Hi ,
In think fiscal calender is a customize calender but
even though you can add wee(Date) + No of weeks diff b/w Fiscal calender and Actual calendar .
Regards
Yusuf
The Week() function cannot be modified.
But there are other functions that you can use to define your own week number. What kind of fiscal year do you have? And does the week always start on the same weekday?
HIC