Comparing Dates in PX jobs

dlvsrinivas · Post by **dlvsrinivas** » Mon Nov 10, 2003 9:11 am

Dear All,

I need to calculate the difference between the current system date and the date passed as an input in months and days using PX job. I have a routine to do the same, but I can't use the same in PX jobs.

Could anybody suggest the functions to be used for the same purpose which takes care of the above purpose? Can we have something similar to routine in PX jobs which can be reused across different PX jobs?

Thanks in advance.

Peytot · Post by **Peytot** » Mon Nov 10, 2003 9:17 am

You can create a Variable into your transform which does the same think that your routine.

Pey

bigpoppa · Post by **bigpoppa** » Mon Nov 10, 2003 9:54 am

The subtraction operator is overriden for the APT_DATE type. You can subtract two APT_DATEs, and the result will be given to you in number of days. You can use other date functions to convert this into MON/DAY/YEARS.

- BP