Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



MS Access VDA Date format

By Petenroz ·
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"

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums