Results 1 to 5 of 5

Thread: Dates

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2001
    Posts
    2

    Cool Dates

    What is the function for changing a date in the date/time format to just the date format without a time?

  2. #2
    Lively Member
    Join Date
    Feb 2001
    Location
    Fort Lauderdale, FL
    Posts
    98
    Format("mm-dd-yyyy")

  3. #3
    Hyperactive Member techman2553's Avatar
    Join Date
    Mar 2001
    Location
    <- To your left.
    Posts
    362
    You forgot the Date argument:

    Code:
    Debug.Print Format(Date, "mm-dd-yyyy")
    ----------

  4. #4
    Lively Member
    Join Date
    Feb 2001
    Location
    Fort Lauderdale, FL
    Posts
    98
    Oops! Sorry. :-)

  5. #5
    Hyperactive Member
    Join Date
    Oct 2000
    Posts
    400
    I won't work in .NET, but in 6.0 you can use:
    Code:
    MyDate = Int(MyDateTime)

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