topic Re: Modifing date in QlikView

Modifing date

Thu, 26 Feb 2015 05:30:51 GMT

Hi all,

I have a field from Database and it contains date in (MM-DD-YYYY) format

I need to update the year part of it.(Cannot update in Database due to some constraints)

eg.

I have 2/24/2010 and i want it to be 2/24/2012, ie adding 2 years only.

Thanks

tresB — Thu, 26 Feb 2015 05:32:54 GMT

Load

AddYears(DateField, 2) as NewDate

jyothish8807 — Thu, 26 Feb 2015 05:38:43 GMT

Hi Deepak,

You can try like this also in script:

load

date(AddMonths(min([Date]),24),'MM-DD-YYYY') as New Date

Regards