I have some time fields formatted to display as HH:MM 24 hour. If you key in something like "3:00 PM" it correctly changes to "15:00" when you exit the field, but if you enter that field again, you see "3:00 PM."

Similarly, if you concatinate data from that field with other stuff in a text field, you don't get "15:00" you 3:00 PM.

I'd like to do an auto-enter replace calculation that changes any AM/PM stuff folks key in to actual 24hr times.

... I'd also love to never see any seconds display in the field ever under any circumstances... but I don't think that's possible as long as it's a "time" field.

Edited December 24, 200520 yr by Guest

Hi

I can't replicate your problem...

even with English version of FM and with International Options of Windows contro pannel setted to English (USA) !

If I enter 3:00 PM, it automatically changes in 15:00:00 and so remains if I enter that field again !

So I'm guessing if you can obtain some result playing with the Windows pannel !

That's interesting... I wonder why. I double checked my Windows settings and I'm also at English USA... but if I enter a time as AM or PM the display changes to 24 hr only for as long as I'm not in that field. When I return (even after exiting and restarting the app) I see the AM/PM again until I exit the field.

I even tried changing my Windows time format to HH:mm:ss (24 hour). Didn't make any differece... unless a reboot is required after the change.

Will try that when I get a chance.

Whenever you click into a time/date/number field that has a DISPLAY format, you will see the original data entry - so that you can edit it in your preferred ENTRY format.

To change the actual entry, set the field to autoenter:

GetAsTime ( timefield )

Changes you make in your OS format settings only affect data ENTRY - and only for files that have been created/cloned under those settings, or are set to use the current system formats.

Thanks. That works.

Always wondered what GetAsTime was useful for!