Time Format

[okachick]

I found in the forums a way to enter time as example 1300 and fmp changes it to the proper time format of 13:00 and what I tried was

Replace ( Right ( "0000" & Timefield ; 4 ) ; 3 ; 0 ; ":" )but when I put it into my db it says it cannot find "timefield";4). I am wondering if this is because I am using FMP 6 although I can't really see why it shouldn't work. Any help on this?

Thank you

[bcooney]

What is the name of the field that has the time value? That is what you need in place of "Timefield" in the calculation.

[okachick]

Thank you for the quick reply. I did put the actual field name in the "Timefield". It is called Time In field from my database but it still won't let me use it. Should I change my field Time IN to a calculating field or leave it as a time field and use option auto-enter using a calculation?

Thanks again

[comment]

For one thing, you must use commas instead of semi-colons. For another, this won't work in version 6, because it has no auto-enter replacing existing value. You need to use two fields: one for entry (could be a text field, if you prefer to enter time in a non-standard way) and another for display (a calculation field with result of type Time).

[okachick]

I guess I will just wait until we upgrade which I hope is soon. Thanks so much for your help

[bcooney]

I'm sorry, didn't see the FM6. Btw, the upgrade from FM6 to FM10 won't be trivial. Depends, of course, on the complexity of your system.