Converting Integer Month/Year to Date

  • Thread starter Thread starter Kirk P.
  • Start date Start date
K

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
 
DateSerial(YearValue, MonthValue + 1, 0) will return the last day of the
month represented by MonthValue
 
Back
Top