Hi all,

I am trying to compare 2 time stamps in order that a stored procedure
can return a records that a re out of date.

FTime= 'Now';
FTime= :FTime - (3/1440);

I am using the above to subtract 3 minutes from "Now" but it does not
seem to be working. FTime remains as now.

I checked that it was not working by outputting the value assigned to
'Now' and both 'Now' and FTime return the same value.

What am I missing ?

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results