Hey All,

I am storing a Date that is input in the format: dd/mm/yyyy and also an agreement length as a number of months. I need to pull a query of all agreements due to end within a month...

So I need to write a query that takes the start date and adds months - 1 and see if the current date is bigger...i think..

but I am really not sure how to go about this..

any advice would be appreciated.

Thanks,

graham.

Do you want to find aggreements that will end in the mext month (as next 28-31 days)?

If yes, try a criterion like:

Seems to work well! Nice one thanks.

You're welcome ... Glad to help ...