Date > Today

[Raven]

I would like a query to return all the records in which a field [Date Required] is equal to or greater than today.

I have put in the [Date Required] criteria >Date() but this doesn't seem to work.

Any suggestions?

 

[jaydwest]

Try

"[DateRequired] > #" & Date() & "#"

 

[Raven]

I got a "Data type mismatch in criteria expression" error.

 

[Rich]

>=Date()

 

[Raven]

I realise my error now.

I actually needed less than today's date to see the 'overdue' tasks, ie

Is Null Or <=Date()

That works! ;-)