Page 1 of 1

Difference betwwen dates

Posted: Wed Mar 16, 2011 12:29 am
by ksv2584
Hi

I will run my job on friday(ex :18/03/2011) .. i need to to take monday date (ex : 21/03/2011) and find the number of days between 01/01/1972 and the monday date

for ref

Date: 010172 Day: 00001


Date: 090472 Day: 00100


Date: 160311 Day: 14320


Please help me in implementing this

Thanks
Vidya

Posted: Wed Mar 16, 2011 12:31 am
by ray.wurlod
Do you want to perform this calculation in a sequence or in a parallel job?

Posted: Wed Mar 16, 2011 12:49 am
by ksv2584
hi

In a parallel job,i need to populate the differnece of days to to o/p file

Thanks

Posted: Wed Mar 16, 2011 1:22 am
by ray.wurlod
You need the DaysFromDateSince() function.