Dear Sir or Madam,



I have a query in the query of my database which finds date equal to 

todays date.I place this in the "Criteria" under the entry date.



*=""&Format(Now(),"M/D/YYYY")*



What query can I write to find all dates 30 prior to todays Date.



Thank You

Criteria to find dates within the last 30 days would be:

>Now()-30



Richard Lobel

Accessible Data

richard@a... <mailto:richard@a...> 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx



>What query can I write to find all dates 30 prior to todays Date.<

--0-61142479-1014843590=:30725

Content-Type: text/plain; charset=us-ascii





 Or you could use DateAdd("d",-30, Now())

  Richard Lobel <richard@a...> wrote: Criteria to find dates within the last 30 days would be:

>Now()-30



Richard Lobel

Accessible Data

richard@a... 

Cell:  (xxx) xxx-xxxx

Fax:  (xxx) xxx-xxxx



>What query can I write to find all dates 30 prior to todays Date.<










Lonnie Johnson, ProDev, Builders of MS Access Databases

Let us build your next MS Access database application. 

http://www.galaxymall.com/software/PRODEV 



Send and Receive payments online for free with PayPal:  http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG





---------------------------------

Do You Yahoo!?

Yahoo! Greetings - Send FREE e-cards for every occasion!