Date calculations

[#1]

Hi

I have a problem with date. In our company, the fiscal year starts in September and some of the data in SAP is based on normal calendar and some are based on fiscal calendar. My question is, what kind of script I should write to convert fiscal year date to normal calendar based date.

Example

Fiscal period 4/2013 means 12/2012 calendar period (Dec 2012)

Thanks,

Regards

Janne

[#2]

Thanks for the quick reply.

However I think this doesn't work (or more likely I am using it wrong), cause this results only year and I would like to get period also.

So how to convert fiscal period 4/2013 --> calendar period 12/2012

Thanks

regards

Janne

[jagan]

Hi,

Try below expression

=Date(AddMonths(MakeDate(Right('4/2013', 4), Left('4/2013', Index('4/2013', '/') - 1)), 8), 'MM/YYYY')

Replace date with you dimension in above expression.

Hope this helps you.

Regards,

Jagan.