Convert Date into string

  • Thread starter Thread starter Stever
  • Start date Start date
S

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
 
i think that


Code
-------------------

Dim TestDate1 As string

TestDate1 = Replace(Me.DRAWING_DATE, "/", ".")
 
Back
Top