Date Query

linskill

Registered User.
Local time
Today, 20:42
Joined
Nov 1, 2012
Messages
38
I am trying to work out how to get a query to return all records from a date starting the month after next.
i.e. query runs late December and returns all values from 1st February onwards.

I have tried
Code:
>=DateAdd("m",2,Date())
but that adds two calendar months and does not return the records earlier in the month.
Can anyone please point me in the right direction.
 
Use dateserial

Dateserial(year(date()),month(date())+2,1)

Lookup dateserial in help.

Brian
 
Thanks Brian, you're a Diamond.
That's a new one for my arsenal.
 

Users who are viewing this thread

Back
Top Bottom