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
BedrockMission!

Learn More

View all

Sign in to view all badges

Time Field Format Conversion

Avatar

Avatar
Validate 1
Level 1
fcbg1234
Level 1

Like

1 like

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
fcbg1234
Level 1

Like

1 like

Total Posts

35 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
fcbg1234
Level 1

20-10-2017

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 4
mouslander
Level 4

Likes

23 likes

Total Posts

298 posts

Correct Reply

27 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
mouslander
Level 4

30-10-2017

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"