HI,
I want to find the difference between two dates in MQSI Version 2.0.1 in terms of days.
I want to subtract two dates and want the difference in terms of number of days and store it in a variable.
I tried the syntax
(CURRENT_DATE - DATE '2000-01-01')DAY.
But this syntax gives syntax error in MQSI V2.0.1 but works with MQSIV2.1
Can anyone suggest a solution.
Thanks in Advance.
[ This Message was edited by: cronydude on 2001-12-28 02:42 ]
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum