Selecting Records Older Than 90 Days

1 reply
238 views
Translate

Can someone tell me an efficient way to select all records that are older then 90 days? I have a field named PostedDate which is the date the record was created. I'm using MS Access.

Thank you!

Getting started

This topic is closed to new replies. Start a new post to keep the conversation going.

L

LL20_2Correct answer

Participating Frequently

This code:
<cfquery name="Myquery" datasource="cfdocexamples">
Select * from employee where startdate < #now()#-90
</cfquery>

Translates to this:

Select * from employee where startdate < 01/17/2006

L

LL20_2Correct answer

Participating Frequently

This code:
<cfquery name="Myquery" datasource="cfdocexamples">
Select * from employee where startdate < #now()#-90
</cfquery>

Translates to this:

Select * from employee where startdate < 01/17/2006

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.