swap years in qlikview

[capriconuser]

Hi 

i have years like this 

01/01/2009 12:00:00 AM

01/01/2010 12:00:00 AM

01/01/2011 12:00:00 AM

now i want to swap only years in date field .. for 2009 i want 2010 and for 2010 i want 2009 and for 2011 i want 2009 ..

how to do that in qlikview script  by using if else condition ?

any help 

[PadmaPriya · Accepted solution]

Hello @capriconuser 

Please have a loot at below articles:

How to Use Simple Date Functions in QlikView and Qlik Sense | EzDataMunch

calendar year to fiscal year - Qlik Community - 1253798

Date and time functions ‒ QlikView

Thanks,
Padma Priya

Qlik Support