Date Criteria

[jim11]

Ive got a table called tblHistory. It contains a field called MOTDate (this field is in date/time data type format set on long date. Im trying to make a query that will display any table entry that has an MOTDate within the next 30 days. I think i need to put something into the Criteria for the MOTDate field in the query, but im not 100% sure.

Any help would be appriciated.

Thanks
Jim

 

[trucktime]

Date

In the Query Criteria field of MotDate put:

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

 

[jim11]

thanks guys, that sorted it