Convert a Date to Character

[Jasmine]

How do I Convert a Date to Character in MsAccess ?

I'm an old Foxpro user and I know there was a command called - DTOC ( date
to character)

Could anyone tell me the equivalent in MsAccess?

 

[Guest]

Use CStr(varTest)

 

[Jasmine]

I appreciate this very much

Thanks a million

 

[John Nurick]

I'd use the Format() function to ensure that the date comes out the
way I want, e.g.
Format(MyDate, "yyyy/mm/dd"

 

[Jasmine]

Outstanding.

I'd use the Format() function to ensure that the date comes out the
way I want, e.g.
Format(MyDate, "yyyy/mm/dd"