How to do Date Math via an ODBC SQL query

[conjur]

I have the following in my WHERE clause:

(release_date > date() - 3)

and it results in the following error:

Error: Incompatible datatypes in expression : > (State:37000, Native Code: F54)

Is there any way to do Date Math in an ODBC query of FM data?

[Leb i Sol]

give this a shoot:

SELECT Table.Release_Date WHERE Table.Release_Date > (now()-3)

is there a scripting step involved prior or after the SQL filter?

Take care!

[conjur]

Actually, I found two things that got it to work.

One, I thought I had the checkbox off to convert Number, Date and Time to text. Well...I didn't. (OOPS!)

Second, I used the today() function as in:

(release_date > today() - 30)