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.
Adding year to date
Moderators: chulett, rschirm, roy
Is the column type a string? If so, just use
Code: Select all
In.DateColumn[1,4]+6:In.DateCoLumn[5,4]
Last edited by ArndW on Wed Dec 12, 2007 8:14 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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]
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>