Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Question Unanswered: Date Format Question

    Quick question, I would like to use the Date() to insert the date but I would like a different format. The Date() produces 10/07/2004 but I need it in 2004-10-08 format.

    Thanks in advance for your help.

    Bob G7

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by Bob_g7
    Quick question, I would like to use the Date() to insert the date but I would like a different format. The Date() produces 10/07/2004 but I need it in 2004-10-08 format.

    Thanks in advance for your help.

    Bob G7
    Hi Bob G7,

    Do this....
    Format(Date, "yyyy-mm-dd")

    Have a nice one,
    Bud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •