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.