How can I subtract two dates in a Parallel JOB?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 161
- Joined: Mon Mar 17, 2008 10:33 am
How can I subtract two dates in a Parallel JOB?
How can I subtract two dates in a Parallel JOB?
Re: How can I subtract two dates in a Parallel JOB?
Use the transformer stage and Date function to substract 2 dates..
Nirdesh Kumar
date1 and date2 are two parameters to the function
Code: Select all
DaysSinceFromDate(date2, date1)
You are the creator of your destiny - Swami Vivekananda
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.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
dayssincefromdate
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