Question: how to calculate months between two dates in datastage?
Answer: *Subtract the two date values, divide by (60 seconds * 60 minutes * 24 hours). EXE. *You may also use the DATEDIFF function. COMPUTE days2 = DATEDIFF(date2,date1,"days").