DSXchange

Posted: **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.

Posted: **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]

Posted: **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]
...

DSXchange

Adding year to date

Adding year to date