I need to generate a date that is the last day of the month from a given, changeable start date based on two optional time periods, 18 or 36 months. That is, the start date is entered in one field, the number of months for the time period is in another. The third field would contain the last day of whatever month occurs when the time period is added to the start date.
Access help showed me a function called EOMONTH - eomonth(start_date,months)
which seemed would do exactly what I want. I got the error message "undefined function in expression". The functions reference list in help which shows all usable functions does not list eomonth.
Is my syntax wrong? In a the query I used:
Date: eomonth([start date from field in query],[number of months from field in query])
Any other suggestions for how to accomplish what I want?
Leslie Shippee
Information Analyst
Access help showed me a function called EOMONTH - eomonth(start_date,months)
which seemed would do exactly what I want. I got the error message "undefined function in expression". The functions reference list in help which shows all usable functions does not list eomonth.
Is my syntax wrong? In a the query I used:
Date: eomonth([start date from field in query],[number of months from field in query])
Any other suggestions for how to accomplish what I want?
Leslie Shippee
Information Analyst