var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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"
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)