COMPARE CURRENT MONTH

[ramrags]

I have a simple db with just one table, the table has 6 fields. One of the fields is called RenewalDate, this is the date that lease renewals are due. I want to create a query that will compare the month part of this date with the current date, and return the accounts that need to be renewed for the Month. Thank you for any help

 

[tlbroadbent]

It is actually quite simple with the Month function.

Select * From Table
Where Month(RenewalDate)=Month(Date()) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[euskadi]

*nods* That works assuming 1 year or shorter lease. For a longer term, you'll need to compare Year() also... unless you want to be reminded now about the lease coming due in October 2002.