Convert to date

[thart21]

Looked through DateSerial but possibly not the way to go. I have a text field, "Month", with the dates in this format: Jan-06, Feb-06. What do I use to convert these to date format? 1/1/06, 2/1/06.

Thanks

Toni

 

[gemma-the-husky]

try

mydate = DateValue("1-" & [month])

access will know "1-jan-06" as a date and convert it to a datetype with datevalue.

 

[thart21]

Thanks a lot, I will try that.