Convert Date into string

[Stever]

I need to convert a field that is a date into a string so I can replace the
/ with a . for use as a folder name. Here is what I have so far. Obviously I
get an error when I try to assign the date field to a string variable.

Dim TestDate1 As string
Dim TestDate2 As String

TestDate1 = Me.DRAWING_DATE
TestDate2 = Replace(TestDate1, "/", ".")

Thanks in advance for any suggestions you may have

Steve

 

[Douglas J. Steele]

Format(Me.DRAWING_DATE, "mm.dd.yyyy") will do it.

 

[yakule]

i think that


Code