[AccessD] character to date datatype conversion?

Gustav Brock gustav at cactus.dk
Tue Aug 26 02:59:54 CDT 2003


Hi Bridget

As Michael suggested, use Format(), but you only need one go:

  txtDate = Format("110203","@@/@@/@@")

If you need a date value and not a string you can use

  datDate = CDate(Format("110203","@@/@@/@@"))
  
or follow Stuart's suggestion.

/gustav

> Is it possible to convert a text field to a date field in Access2K?
> eg > 110403 to 11/04/03

> Thanks
> Bridget



More information about the AccessD mailing list