> How to calcuate the days between two DATE fields? I tried to using
> the following statement in one of my stored procedure, but it failed
> to compile it:
>
> Days = :INVOICE_DATE - 'TODAY'

Days = INVOICE_DATE - CURRENT_DATE;



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com