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