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