Hi Paul,

If you are using dialect 3, try CURRENT_DATE instead of 'TODAY'. I tried the
following and it worked without an error.

SELECT * FROM customer WHERE Date_inserted > current_date - 30

Regards,
John.

----- Original Message -----
From: "Paul Schmidt" <paul@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 19, 2002 8:53 PM
Subject: [ib-support] Aged Dates


>
> Dear List:
>
> I am using Firebird running on Linux Version (LI-T6.2.681 Firebird
> Release Candidate 2) .
>
> I have a set of dates in a table, and I want to split them up as 30.
> 60, 90 etc. I would have thought that
>
>
> SELECT FIELD1 FROM TABLE1 WHERE TABLE1.DATE >
> 'TODAY' - 30
>
> Would do it, but I get:
>
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> expression evaluation not supported
>
> None of the UDFs for Linux seem to have an aging function (I know
> FreeUDFLibC has one, but it doesn't work correctly, and only
> works with months).
>
> Paul
>
>
>
>
>
> Paul Schmidt
> Tricat Technologies
> paul@...
> www.tricattechnologies.com
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>