How to calculate Previous year date by using curre... - Qlik Community

Report Inappropriate Content · ‎2014-09-24

Hello Everyone,

I have Date column, i need to get previous year date,

For ex: i have 01/01/2014, i need to get 01/01/2013,

Please help how to write a formula at script level

Thanks in advance

PrashantSangle · ‎2014-09-24

Hi,

You can use AddYears() or AddMonth()

like

AddYears(dateField,-1)

or

AddMonths(dateField,-12)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

How to calculate Previous year date by using current year date