TechRepublic|Forums|Software

Software

Question

  • Creator
    Topic
  • October 31, 2017 at 3:30 am #2342530

    MS Access VDA Date format

    Locked

    by petenroz · about 5 years, 7 months ago

    Tags: ,

    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”

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

Share your knowledge