Question Locked

MS Access VDA Date format

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi 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 = 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"

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.