Date Arithmetic

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
jseclen
Participant
Posts: 133
Joined: Wed Mar 05, 2003 4:19 pm
Location: Lima - Peru. Sudamerica
Contact:

Post by jseclen »

Hi Santosh,

I send you the rotuine to calculate the months from two dates,

Ans = Int((IConv(Arg2,'D/E') - IConv(Arg1,'D/E')) / 30)

Where Arg1 is the mininum date
Arg2 is today (can be any date, but greater than Arg1

Hope this help

MS.

Miguel Seclen
Lima - Peru
jseclen
Participant
Posts: 133
Joined: Wed Mar 05, 2003 4:19 pm
Location: Lima - Peru. Sudamerica
Contact:

Post by jseclen »

respect the last item, the date format that you must be use is dd/mm/yyyy to use the routine.

MS.

Miguel Seclen
Lima - Peru
Post Reply