Convert date into text

[Guest]

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

 

[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")

 

[Guest]

Thank you worked just fine.

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")