Fiscal Month

[markgraham123]

Hi all,

I'm trying to generate Fiscal month based on Fiscal week.

1.     check monday of every week  - give the month number of monday's date -1  as fiscal month for the date

Can someone please help?

Any help is highly appreciated.

[swuehl]

"give the month number of monday's date -1 "

Do you want to actually the month number of Sunday (Month(Monday's date -1)), or do you want to range your month numbers from 0 to 11 ((month number of Monday's date)-1) ?

Maybe like this (assuming weekstart is defined as Monday):

Month( WeekStart( DateField) -1) AS MonthField

or

Month(WeekStart(DateField))-1 AS MonthField