Date to String in VBA

[aabob]

Pardon the newbie question, but how do I convert a date to a string in my VBA code for the purpose of evaluation?

Foxpro uses 'DTC' but I can find the VBA way.

Thanks.

 

[nickjar2]

I think maybe cStr,
although when I haven't got access/vba in front of me my mind goes blank and I tend to give wrong answers.

Nick

 

[ide]

Syntax
Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

'***********************************************************************
Dim MyTime, MyDate, MyStr
MyTime = #17:04:23#
MyDate = #January 27, 1993#

' Returns current system time in the system-defined long time format.
MyStr = Format(Time, "Long Time&quot

' Returns current system date in the system-defined long date format.
MyStr = Format(Date, "Long Date&quot

MyStr = Format(MyTime, "h:m:s&quot ' Returns "17:4:23".
MyStr = Format(MyTime, "hh:mm:ss AMPM&quot ' Returns "05:04:23 PM".
MyStr = Format(MyDate, "dddd, mmm d yyyy&quot ' Returns "Wednesday, Jan 27 1993"

ide