Time Field Formatting

[Baylah]

Is there a way that I can set up a time field so that if I enter a time of 930 that FMP will automatically format it to 09:30. or 1337 would auto format to 13:37, etc, etc.

I can easily do this in (dare I say it) Access using input masks (as I can with phone numbers...but I digress) but I have not found a way to automate this annoying little data entry task in FMP.

Thanks

Steve

[TheBigEye]

You need your field to be the time type and the when you put it in your layout right click it, choose "time format..." then "format as:" and choose your options

[Baylah]

I've tried that, it does not properly mask the entries as I would like. I have tried everything I can think of on that along that line. I am quite familiar with (or thought I was)the "Format Time" dialog.

I was wondering if there is something that I am missing.

My mission:

type 930 in field, FMP formats that to 09:30.

type 1937 (or something like that) and FMP returns 19:37.

Any help out there?

Thanks,

Steve

[comment]

Make your time field auto-enter the following calculation (replacing existing value)

Replace ( Right ( "0000" & Timefield ; 4 ) ; 3 ; 0 ; ":" )

[Baylah]

Perfecto!

You're the best

Steve