Hello Grant,

GB> Found the problem
GB> When I changed

GB> FTime= 'Now' - (3/1440);

GB> to

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

GB> the error went away.
GB> Seems to me they both equate to the same thing.
GB> Could someone expalin why the error ?
'Now' is just a string, which can be recognized by FB and
auto-converted to a timestamp. I suppose that in your expression FB is
confused. I think the following construction should work fine:

FTime = cast('Now' as TimeStamp) - 3/1440;


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com