Selecting Records Older Than 90 Days

Forum|Forum|20 years ago
April 17, 2006
1 reply
238 views

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.

Correct answer LL20_2

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

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.