Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable vFM which denotes the month number in which the financial (Fiscal) year starts.
I have the following Calendar Year flag expressions:
MonthName(today()) as This_Month,
MonthName(AddMonths(today(),-1)) as Prev_Month
How can i change these to give the corresponding financial (Fiscal) year equivalents, i.e. FiscalThis_Month and FiscalPrev_Month?
Regards.
Chris
The MonthName function returns the name of a month. Using a fiscal calendar does not change the names of months. April will still be April, regardless of it being the first, fourth or tenth month of your fiscal calendar.
dont get your question
These may help:
Fiscal and Standard Calendar generation
Thank you
Thanks for the links