Date Difference
Posted: Thu May 11, 2006 4:21 am
Hi Guys
Could you please tell me how can i get date different in Datastage(server) without using the user defined Routine/function.
Example: 07/02/2006 and 03/01/2005 (any format )
output: 04/01/0001
(i need in Data stage)
i got one function here like:
DateGenericDateDiff(1st date, 2nd Date) in dx7.5
but i am not getting my requirment .
please do the needful.
Thanks
-Mspanda
Could you please tell me how can i get date different in Datastage(server) without using the user defined Routine/function.
Example: 07/02/2006 and 03/01/2005 (any format )
output: 04/01/0001
(i need in Data stage)
i got one function here like:
DateGenericDateDiff(1st date, 2nd Date) in dx7.5
but i am not getting my requirment .
please do the needful.
Thanks
-Mspanda