william_yuwei wrote:

> Hi,
>
> 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'
>

'Today' is just a string that has a particular meaning when interpreted
as a date - either use CURRENT_DATE or cast 'Today' as a date.

Regards,

Ann