How to make operations on date fields

jseclen · Post by **jseclen** » Wed Jan 16, 2008 5:06 pm

Hi Forum,

I'm working in Data Stage Enterprise 7.5.2 in AIX server 5.3, and i need to obtain the difference between two dates, in server version i use iconv for both fields and obtain the result, but in parallel i can't ..

Anybody has an answer ??

Is there another choice to obtain this result??

Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Jan 16, 2008 5:50 pm

In Appendix A of the Parallel Job Developers Guide is a list of all the Transformer stage functions.

My first guess would be to use DaysSinceFromDate(). In a Modify stage this function is called days_since_from_date()

My second guess would be to apply JulianDayFromDate() to both dates and subtract. In a Modify stage arithmetic is not possible.