Calculating Service period using difference betweeen 2 dates

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Calculating Service period using difference betweeen 2 dates

Post by vinodn »

Hi

I have a requirement to calculate service period subtracting 2 dates?
How can I approach this issue?

Thanks
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Re: Calculating Service period using difference betweeen 2 d

Post by vinodn »

vinodn wrote:Hi

I have a requirement to calculate service period subtracting 2 dates?
How can I approach this issue?

Thanks
Plss help me out with this issue....
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

days_since_from_date
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Post by vinodn »

ArndW wrote:days_since_from_date
Thanks, but can you further help my understanding?

I want the no. of days between Date1 and Date2

Will this work?

DaysSinceFromDate(Date1,Date2)
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

vinodn,

please read the PDF first, then try what it says and if you still have problems, post it here.
Post Reply