Results 1 to 4 of 4

Thread: format date

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2000
    Posts
    23

    Question

    Hi everybody!
    can anybody tell me if it is possible to use the FORMAT function to make a date read EG: 9/11/00 rather than 11/9/00 ?
    Thanks in advance for any advice!!

  2. #2
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    <?>

    myDate = Format(Date,"dd/mm/yy")
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."

    ___ Adolf Jensen

  3. #3
    Frenzied Member
    Join Date
    Sep 1999
    Location
    Phoenix, az
    Posts
    1,517

    No Problem

    MsgBox Format(Now, "d/m/yyyy")

    or

    MsgBox Format(Now, "m/d/yyyy")

  4. #4
    New Member
    Join Date
    Oct 1999
    Posts
    14

    This also puts in the EG:

    Format$(Now, "EG: dd/mm/yy")

Posting Permissions

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



Click Here to Expand Forum to Full Width