Date BETWEEN

[AccessFreak]

Sorry for this question. Its STUPID.

I have a query with a date field. I need to get al the dates from 6 moths ago untill now.

I thought it was something like this:

Date BETWEEN Date() AND ....< i dont know what to set here..

 

[Mr. B]

Take a look at the DateAdd function. You can use it to provide the length of time to go back.

 

[lawtonl]

Try >= [Date] and enter the date when the box appears. That's how I do it and it works for me.

 

[boblarson]

For 6 months ago till now, use:

Between DateAdd("m", -6, Date()) And Date()

 

[AccessFreak]

For 6 months ago till now, use:

Between DateAdd("m", -6, Date()) And Date()

Thanks man.. your great. I knew it was DateAdd or DateSerial.. i See i did date() before DateAdd().. that was the problem..

Thank for all.