Convert a Numeric Month Value to a full Date Value

[jaaret]

I have a combo box that lists the months values: 1-12. How can I extrapolate that into a date value representing the first of the month?

'Concatonate month with text to create a date string
=([cboMonth] & "/1/2008")

How can I combine this with the DateValue function to convert the resulting string to a true date value?

Jaaret

 

[Remou]

You can use DateSerial:

dteDate=DateSerial(2008,MonthVar,1)