Difference betwwen dates

ksv2584 · Post by **ksv2584** » Wed Mar 16, 2011 12:29 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Mar 16, 2011 12:31 am

Do you want to perform this calculation in a sequence or in a parallel job?

ksv2584 · Post by **ksv2584** » Wed Mar 16, 2011 12:49 am

hi

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

Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Mar 16, 2011 1:22 am

You need the DaysFromDateSince() function.