days between two dates

[arunkumar1111]

Hi

I'm using datastage 7.5.2 edition. I need to find difference between two dates. when i gave date1-date2 the error is

Error in Stage Variable derivation expression for variable DateDiff. Invalid conversion requested from a date to a dfloat.


Please can any one help on this.

Thanks and Regards
Arun

Known is a drop and unknown is an Ocean

[dhanashreepanse]

Use the JulianDayFromDate function for both the dates to convert them to a number.
Then do the subtraction.
And then convert this number back to a date using DateFromJulianDay function.

-Dhanashree.