Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.