Time formatting

[lonesomejubilee]

Hi, I'm a newbie so forgive me if this is easy. I am trying to format the time field in a layout. I went to the options in the field property and set it to "hhmm" with a ":" separator. It is showing up "1535:00". I don't . I have the other settings to 'none'. I can't figure out how to make it look lik e"15:35". Got any ideas?

[dbruggmann]

You have to enter "15:35"; if you enter "1535", Filemaker assumes that are 1535 hours.

[Lee Smith]

Hi Vandy,

Go to Layout Mode, click on the field and then go to Menu, Format, Time.

In the dialog menu that will appear, the Option to change this is 2nd one called: Format As:

It's a drop down menu.

HTH

Lee

[lonesomejubilee]

Hi. I changed it to "hhmm", but it still is formatting funny. By the way in response to Bruggmann, I want the user to be able to type in t"1535" and have the computer automatically put in the ":" separator. So it says "15:35". If you can't get it to format this way, will is still work in find and query situations? ... the 1535?

[ESpringer]

Vandy,

You don't have a profile showing what FM version you're using. It may be possible to have FM7's auto-enter calc option "correct" the input you're describing so that it will adjust what *seems* to be a number of hours (on FM7's way of understanding time input) so that it will count instead as hh:mm.

[lonesomejubilee]

Sorry about that. I use FM Pro Dev 7. But I will need to use the time field in finds (for instance, give me all the things that happened between x and y... or how much time has expired between x and y... so that's the most important thing, the format is only the icing.

Thanks

Vandy

[-Queue-]

You may want to display a calculation time field like

Let( x = Right( "0000" & pseudotimefield; 4 ) & "00"; Time( Left( x; 2 ); Middle( x; 3; 2 ); Right( x; 2 ) ) )

on top of your pseudotimefield (with a solid background fill and formatted as hhmm), and only allow entry to the pseudotimefield. Then you can enter 1535, see 15:35, and search for 1535, assuming of course that you've formatted the calculation field on the layout as 24 hour time.

[CobaltSky]

ESpringer said:

It may be possible to have FM7's auto-enter calc option "correct" the input you're describing...

Yes. I believe that Elise is on the right track here. There should be no need for stacking fields.

Attached is an example which shows how one might go about it.

TimeTrick.zip

[-Queue-]

Hmm, I thought the desire was to enter and find normal number fields, but format as time. Hence the need for stacking and not overwriting the original number. I think I misconstrued a few of the posts.