Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    6

    Unanswered: Format to actual short date (no time)

    ON FORM LOAD I FILL A TEXT BOX WITH TODAY'S DATE USING NOW(). THE FORMAT IS SHORT DATE IN THE FORM AND TABLE. (8/16/2012) HOWEVER THE ACTUAL DATE LOADED IS (8/16/2012 3:50:25 PM) AND THE ADDED TIME, CAUSES A QUERY NOT WORK SINCE IT IS LOOKING FOR JUST THE DATE IN THE CRITERIA.
    HOW CAN I FORMAT THE TEXT BOX TO ACCEPT AND CONTAIN THE DATE ONLY?
    THANK YOU

  2. #2
    Join Date
    Mar 2009
    Posts
    5,441
    Provided Answers: 14
    If you don't want to store the Time part, you should use the Date() function instead of the Now() function.
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    dont understand
    CAUSES A QUERY NOT WORK SINCE IT IS LOOKING FOR JUST THE DATE IN THE CRITERIA.
    unless you are storing the date as text NOT as datetime.
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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