Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
MS Access VDA Date format
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 = Date
prev = 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"