Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Time Field Format Conversion

Avatar

Level 3

I have a time field that works fine if you enter Military time format, 1336 is converted to 1:36 PM or 0245 is converted to 2:45 AM.


I might be reaching for the stars but Is there a way to somehow enter standard time and have it converted to the actual format?  Something like, 136p is converted to 1:36PM or 245a is 2:45 AM?

Thanks!

0 Replies

Avatar

Level 7

you should be able to achieve this through a Regular Expression. You would write it for the exit event so that when the user enters 136p they would get 1:36pm. The regular expression would add teh ":" and replace p or P with "PM"