Select Query Question - Date Range

[OBarry]

Can anyone tell me what criteria I can use in a select query to specify the date range as Today's Date plus Thirty days?

Thanks for anyone's help or advice in advance!

 

[DougP]

There may be other ways to do this but this works for me.
Put this in your queries Criteria in its Date field
Between Today1() And Plus30()

Add these two functions to a module
----------------------------
Public Function Plus30()
Plus30 = DateSerial(Year(Now), Month(Now), Day(Now) + 30)
End Function
---------------------
Public Function Today1()
Today1 = Format(Now, "mm/dd/yy&quot
End Function
------------------------

I just checked it out and it works great.
;-)

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[MichaelRed]

How about:

Between Format(Now(), "Short Date&quot and DateAdd("d", 30, Format(Now(), "Short Date&quot

Just to avoid the function call.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[OBarry]

Thanks for your response, both work great but I ended up using...

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

accidently ran across this in the Access help file when I was looking for help for something else.