Numbering based on date

[kishorj1982]

Hi All,

PFA.

I need to use numbering from 1 to 12  from Jun 2017 to May 2018 .

Can you pelase suggest how to do it dynamically.

thanks

[Anil_Babu_Samineni]

In your model ,I have not seen any related Jun 2017.... And you have numeric months too like MonthNo. If you want you can use that

OR

If you want to load missing dates i believe you may need master calendar for that.

[hic]

The following will give you a month number where June 2017 is equal to 1.

=12*Year(DtDate) + Month(DtDate) - 24209

HIC

[effinty2112]

Hi Kishor,

Try:

Mod(MonthNo-6,12)+1

Cheers

Andrew

[#5]

Hi Kishor,

I have a similar situation here, our customer usually have a different year start and end than the standard(JAN to DEC), we get that information from their Data Base, identifying which period refers to which year, if you only have one period per year, you can use that.

Often we use a interval match to make a relation between this new time period and the revenue and such.

Hope this helps.

Gabriel