Modifing date

[#1]

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 · Accepted solution]

Load

          AddYears(DateField, 2) as NewDate

[jyothish8807]

Hi Deepak,

You can try like this also in script:

load

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

Regards

KC