DAte within Query

[Bartman]

I new to this area and I am trying to sort out a little problem that someone should know easily. I have a date field and I want to set up a criteria that will give me any dates that fall within a period of now() + 30 days. Could somebody please help me out

 

[Mile-O]

Look up the DateAdd function in the help files.

 

[Bartman]

Date Add

Have tried looking at DateAdd but cannot get my head around it. I want all results within a 30 day period shown. Have tried to use date add but it doesn't give me any results.

Please help

 

[Mile-O]

As your criteria:

Between Date() And DateAdd("d", 30, Date())

 

[kbreiss]

Here is the where statement in a query that I did...I think similiar to what you are trying to achieve.

WHERE [FORMS]![My_Switchboard]![COMBO8]=[FACILITY].[FAC_ID]
AND [APPOINTMENT].[APPT_DATE] BETWEEN Date() AND DateAdd("d", 7, (Date()))

What this query that I have written does is give me the data that I want in my select date where the APPT_DATE is between the current date (DATE() ) and 7 more days from that date.

Hopefully this helps

Kacy
________
AVANDIA CLASSACTION