Convert date to period (March Year End)

[paul_ripley]

Hello

I have a date and I need to convert it to a period

For example the below coverts 31/12/2017 to 201712

=Date(floor(close_date),'YYYYMM')

However we have a march year end and 31/12/2017 for us is 201709.  So I kind of have to deduct 3 months to get from 201712 to 201709.

Can anyone suggest how to do this?

Many thanks

Paul

[sunny_talwar · Accepted solution]

May be this

=Date(MonthStart('12/31/2017', -3), 'YYYYMM')

[paul_ripley]

Hi Sunny

Many thanks for your help

Paul