Exires next two months

[iPirate]

Hi there, second post still as simple as the first.

i'm currently pumping out all the possible queries/reports i think this database needs and i've found myself stuck on another date related error.
I'm tryng to get a query to pull out records that will expire in the next 2 months and i can't work out what i want to put into the criteria in the "expiry date" field.

Cheers
iPirate

 

[namliam]

Look at the dateadd function in the help that will get you there...