Results 1 to 5 of 5

Thread: Format a date

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 1999
    Location
    Belgium
    Posts
    98

    Post

    Hello,

    How can I format a date ? the result must be
    "dd/mm/yy"

    for example:

    Dim MyDate as Date

    MyDate = Now()

    The result is always "dd/mm/yy hh:mm:ss"

    How can dump the "hh:mm:ss" ?

    R@emdonck

  2. #2
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,175

    Post

    Look up the Format function in Help. One of the "named" (built-in) formats for dates is Short Date and it's used like thisMsgBox Format(Now(), "Short Date")

    ------------------
    Marty

  3. #3
    Fanatic Member
    Join Date
    Oct 1999
    Location
    MA, USA
    Posts
    523

    Post

    This seems to work:
    Code:
    Dim MyDate As Date
    MyDate = Format(Now, "hh:mm:ss")
    ------------------
    Visual Basic Programmer
    ------------------
    PolComSoft
    You will hear a lot about it.


  4. #4
    Member
    Join Date
    Dec 1999
    Posts
    37

    Post

    This uses the format string "m/d/yy", which displays the month, day, and a two-digit year.

    Code:
    Dim MyDate As Date
    MyDate = Now()
    Text1.Text = Format(MyDate, "m/d/yy")

    [This message has been edited by Ruchi (edited 12-13-1999).]

  5. #5
    Lively Member
    Join Date
    Nov 1999
    Posts
    98

    Post

    here are many formats you can use:

    d = one digit date
    dd = two digit date
    ddd = abbreviated day name
    dddd = full day name

    m - one digit month
    mm = two digit month
    mmm = abbreviated month name
    mmmm = full month name

    yy = two digit year
    yyyy = four digit year

    use any of those formats with wach other in this code:

    Text1.Text = Format(MyDate, see above formats)

    for instance...
    Text1.Text = Format(MyDate, dd/mm/yy)
    will return 27/01/99

    or

    Text1.Text = Format(MyDate, dddd mmm dd, yyyy)
    will return Wednesday Jan 27, 1999

    hope this all helps. happy programming!!

    --michael

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