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

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

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

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

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

Perfecto!

You're the best

Steve