PC Review


Reply
Thread Tools Rate Thread

Custom real time, time format check

 
 
bear
Guest
Posts: n/a
 
      12th Mar 2010
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!
 
Reply With Quote
 
 
 
 
bear
Guest
Posts: n/a
 
      12th Mar 2010
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Local Apparent Time (LAT) - real / actual solar time ? Kelvin Microsoft Excel Worksheet Functions 1 25th Oct 2009 02:19 AM
Length of time from date/time custom format Andrew Microsoft Excel Misc 2 21st Sep 2009 04:20 PM
New Feature Request: Outlook real-time spell check =?Utf-8?B?V2F5bmU=?= Microsoft Outlook Discussion 1 20th May 2005 07:23 PM
excel focus problems with custom RTD server (real time data) S Guy Microsoft Excel Programming 3 1st Feb 2005 06:24 PM
Examples of sites with real-time time/date stamps? Peter Sale Microsoft Frontpage 4 11th Aug 2004 07:02 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:37 AM.