DSXchange

How can I subtract two dates in a Parallel JOB?

Use the transformer stage and Date function to substract 2 dates..

DaysSinceFromDate() Returns the number of days from source date to the given date

date1 and date2 are two parameters to the function

Depends on what you want as your output. Do you need the date or the number of days between the dates? If you are interested in Date as an output, you can convert the dates in Julian, find the difference and then convert it back to Gregorian. I have done that in the past successfully.

anbu wrote:date1 and date2 are two parameters to the function

Code: Select all

DaysSinceFromDate(date2, date1)

Before answering question see once.dont give wrong answers.how to subtract dates using dayssincefromdate .once u go through the syntax