Question
-
Topic
-
MS Access VDA Date format
LockedHi i want to use the date as part of a file name
but i want the format as yyyymmdd
below is my start but it will put the date in the wrong format even if it works
really appreciate help as i struggle with this
here is the relevant part/s of the Private Sub
Dim MyDate
MyDate = Dateprev = rs.Fields(4)
path1 = path + “\”
path1 = path1 + MyDate
path1 = path1 + “-”
path1 = path1 + rs.Fields(23)
path1 = path1 + “-”
path1 = path1 + rs.Fields(4)
path1 = path1 + “.pdf”
All Answers
Share your knowledge
Answer This