Adding year to date

rafidwh · Post by **rafidwh** » Wed Dec 12, 2007 4:31 am

Hi All,

How to add 6 years to a incoming date in yyyymmdd format.
The source and target both are sequential files.

Please let me know if there are any functions to convert,add etc..

Regards,
Rafidwh.

ArndW · Post by **ArndW** » Wed Dec 12, 2007 4:53 am

Is the column type a string? If so, just use

Code: Select all

In.DateColumn[1,4]+6:In.DateCoLumn[5,4]

JoshGeorge · Post by **JoshGeorge** » Wed Dec 12, 2007 6:40 am

This works unless the incoming date is Feb 29, in which case you also need to subtract 1 from the day number.

ArndW wrote:Is the column type a string? If so, just use
Code: Select all
In.DateColumn[1,4]+6:In.DateCoumn[5,4]
...