Date Query (1 Viewer)

[linskill]

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

>=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.

 

[Brianwarnock]

Use dateserial

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

Lookup dateserial in help.

Brian

 

[linskill]

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