Search records with a specific expiry date

[ScottXe]

I have a task completion database. Each record of model consists of an expiry date. I need to review and update the records before the expiry date. Each model may have more than one record as I have updated the models a couple of times. I would like to select all of records with the expiry date less than 30 days so I can plan to review and update them on time. Can someone guide me to select all these records. Thanks!

 

[CJ_London]

assuming you mean less than 30 days from today then you will need something like

WHERE expirydate between date() and date()+30

 

[ScottXe]

CJ,

Many thanks for your guidance and I have worked it out.