working with many dates in querly

[jonamua1971]

i have searched this forum but i havent found anything that am looking for.
i have five dates that i would like to pop up 30 days before the actual date and below is the code that am using
Between Format(DateAdd("d",-7,Date()),"mm/dd/YY") And Format(DateAdd("d",+30,Date()),"mm/dd/YY")
the problem is that all dates are poping up,
then i use the report to show all the dates.

Querly
Field 1.first aid 2.cpr. 3.RR 4. Annual training
Table tr tr tr tr
Criteria dates as above
thanks inadvance for any help.

 

[HiTechCoach]

Are your fields of the data type date/time? If they are then you need to use date data types in your criteria.

The Format() function returns a string.

I would try this:

[YourDatefield ] <=  (DateAdd("d",+30,Date()))

The part you posted is not enough to tell anything. It would help is you would post the complete SQL statement. Is that possible?