first month of the year

[icekube88]

is there a way to set the first month of the year cause where using the fiscal year ex.

it start with

april 2004 to march 2005
can i set april to be the firls mon of my year?

is there a way that i can change the calendar year to
fiscal year

 

[ArtieChoke]

If you mean the base month in date functions, then no. You'll need to subtract an offset amount to convert between fiscal and calendar years.

In the case you show above, you can use something like this (if you need the individual values):

calyear = 2004
calmonth = 4

fiscalmonth = calmonth - 3
fiscalyear = calyear
if calmonth < 0 then
calmonth = calmonth + 12
fiscalyear = fiscalyear - 1
endif

Or if you have a date value, use datediff("m",-3,caldate) to get fiscal date (assuming I have the correct order for the arguments).

"I think we're all Bozos on this bus!" - Firesign Theatre