Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Alpine Califormia

    Unanswered: Data Validation Rule

    I need a rule in place on the table that tells the user that they have to input the data on a field in the format of

    10/27/2014 6:00 AM

    This formula isn't working can someone tell me what I'm doing wrong

    Format([Date Returned],"m/dd/yyyy h:nn:ss ")>"00:00:00"

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 35
    Date doesnt care about the format. You can put it in upside down but as long as it is a valid data/time it wont care.
    NOW you can set the text box to 'show' the date in any format you want to see it.

    You can even make 2 boxes , 1 for date, 1 for time, the 3rd box would merge the 2 in the correct way for the table.
    (you have to lead users by the hand...the separate boxs works best for me)

Posting Permissions

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