Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    128

    Question Unanswered: Date and Time isolating

    Hi all,
    If I have a textbox called Date. This TextBox has date and time going together, I want to isolate the date from the time.
    e.g:
    23/11/04 6:00 AM ---> Date: 23/11/04 Time: 6:00 AM
    Best regards...

  2. #2
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    set txt box to
    Code:
    ="Date: " & Date() & " Time: " & Time()
    Darasen

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    or for a field use

    Code:
     "Date: " & Format([yourDate],"dd/mm/yyyy") & "Time: " & Format([yourDate],"hh:nn:ss")

Posting Permissions

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