Function to convert Text to date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I need to convert a date currently in text format (e.g August 2003)
to a date format (1/8/2003) that I can perfrom some calculations on.

Any help would be appreciated

Thanks

Steve
 
Try using the functions CDate or DateValue. Either one should convert that
to a date.

Given a month name or month abbreviation and a 4-digit year (or a 2-digit
year that can't be a day in the month) the functions will return the 1st day
of the month and year as a date.

To be safer you could do
DateValue("1 " & [Your field with a date string])
 
Back
Top