topic Convert date to period (March Year End) in QlikView

Convert date to period (March Year End)

paul_ripley — Wed, 07 Nov 2018 12:31:43 GMT

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 — Wed, 07 Nov 2018 12:38:07 GMT

May be this

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

paul_ripley — Wed, 07 Nov 2018 13:54:33 GMT

Hi Sunny

Many thanks for your help

Paul