Custom real time, time format check

B

bear

Hello

I have a custom form that has two time fields.

How can I force users to enter time in those fields as "12:00 AM/PM" or military time 19.00. If input does not match those two rules, pop a warning. This needs to happen as the user moves to another field way before trying to save the form.

Any help would be appreciated!
 
B

bear

bearsgone wrote on Fri, 12 March 2010 14:2
Hello

I have a custom form that has two time fields.

How can I force users to enter time in those fields as "12:00 AM/PM" or military time 19.00. If input does not match those two rules, pop a warning. This needs to happen as the user moves to another field way before trying to save the form.

Any help would be appreciated


Here is what tried to validate the time:

a. [Test101] <> #h:mm am/pm# did not work
b. Format( [Test102], "h:mm") did not work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top