All Forums UDA
shashankred 2 posts Joined 10/08
25 Feb 2009
Subtract a column from another column with a different datatype

Hi I have two columns Close time(Integer) and pickup Completed Time (Date) .How do I subtract Close time from Pickup Completed where both columns have different data types Can anybody give me the exact syntax Any help would be appreciated Thanks Shashank

CarlosAL 512 posts Joined 04/08
26 Feb 2009

In fact, DATE is INTEGER: (YEAR - 1900) * 10000 + MONTH * 100 + DAYCheers.Carlos.

You must sign in to leave a comment.