Convert date into text

A

Akrt48

Could someone please explain how to convert a date back into text. As in
31/03/06 to 20060331. Thanks
 
K

Ken Snell \(MVP\)

Here's an easy way, assuming that the date format of dd/mm/yy that you show
is in your local settings and that the date is a date value:

Format(TheDateValue, "yyyymmdd")
 
A

Akrt48

Thank you worked just fine.

Ken Snell (MVP) said:
Here's an easy way, assuming that the date format of dd/mm/yy that you show
is in your local settings and that the date is a date value:

Format(TheDateValue, "yyyymmdd")
Click to expand...
 
Top