Converting Integer Month/Year to Date

[Kirk P.]

Is there a function or anything else I can do to convert a
Year and Month field to a date formatted to the last day
of the month?

For example, I am looking for:

Year Month Date
2003 1 1/31/2003
2003 2 2/28/2003
2003 3 3/31/2003

Any help would be appreciated!

Thanks

 

[Douglas J. Steele]

DateSerial(YearValue, MonthValue + 1, 0) will return the last day of the
month represented by MonthValue