Max YearMonth

[rido1421]

Hi There

I want to create a fiscal YearMonth field (201501)

I currently have  [Fiscal Year] and [Fiscal Month] fields

I have done the below but doesnt work for me

[Fiscal Year]&[Fiscal Month] as FiscalYearMonth= 20151

when I Max(FiscalYearMonth) = 201412  ,it should be 201504 as the fiscal year starts in October.

how can I achieve this?

Your assistance is appreciated.

[anbu1984]

[Fiscal Year]&Num([Fiscal Month],'00') as FiscalYearMonth

Or

[Fiscal Year]&Right('0'&[Fiscal Month],2) as FiscalYearMonth

[rido1421]

This seemed to work quite well

[Fiscal Year]*100 + [Fiscal Month]  as FiscalYearmonth,

[jagan]

Hi,

Check this thread

Fiscal and Standard Calendar generation

Regards,

Jagan.