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?

Use CStr(varTest)
--
BrerGoose
Moose-Tech Software:
http://ourworld.compuserve.com/homep...e/MTS/Home.htm

I appreciate this very much

Thanks a million




"BrerGoose" <(E-Mail Removed)> wrote in message
news:29FBB8F7-75CE-4FE1-BED2-(E-Mail Removed)...
> Use CStr(varTest)
> --
> BrerGoose
> Moose-Tech Software:
> http://ourworld.compuserve.com/homep...e/MTS/Home.htm
>
>

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



On Sun, 4 Nov 2007 12:34:22 -0500, "Jasmine"
<(E-Mail Removed)> wrote:

>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?
>
>
--
John Nurick - Access MVP

Outstanding.




"John Nurick" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'd use the Format() function to ensure that the date comes out the
> way I want, e.g.
> Format(MyDate, "yyyy/mm/dd"
>
>
>
> On Sun, 4 Nov 2007 12:34:22 -0500, "Jasmine"
> <(E-Mail Removed)> wrote:
>
>>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?
>>
>>
> --
> John Nurick - Access MVP