Custom Time format - value of field not equal to change made

Forum|Forum|10 years ago
February 12, 2016
2 replies
799 views

I have a field that has a custom time format of HH:MM:ss tt which be default is Military time. therefore if a user enter 01:20:11 pm it will change to 13:20:11 pm however, the value of the field is still what the user entered 01:20:11 pm. How do I get the fields value to equal what it changed to?

This topic has been closed for replies.

G

gkaiseril

Inspiring

Military time format woks with hundreds hours and has no ":" separator. Civilian 24 hour time format uses the ":".

I would use the Civilian 24 hour time format because not Military time format is treated as an IEE floating point number and not a character string which makes computations more complex and harder to work with.

Italian4215Author

Inspiring

I'm using Civilian 24 hour time. the way the format works for 24 hour time is...

if user enter 03:20:20 pm it will convert the display to 15:20:20 but the value of the field will still be 03:20:20. I need the value of the field to equal what it displays, so for this example 15:20:20. I need the value to change as well as display, not just the display. I am pulling info from this field with another program and I need it to be military time for the value since I am pulling that info.