sql query to return records 45 days old

[agmac]

Need help with an sql query that returns only those records in a table that are 45 days old.

The table does have a date/time column (called re_time) that used the now() function to place the date/time into it.

Agmac

 

[agmac]

I figured it out...

WHERE mycolumn > DATEADD('d', -45, now())

Works using ASP and Access DB for those out there that might need to know this..

Agmac

 

[r937]

doesn't work in ANSI SQL, though ;-)

r937.com | rudy.ca

 

[PHV]

A simpler way in JetSQL:
WHERE mycolumn > Date()-45

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886