lonesomejubilee Posted June 24, 2004 Share Posted June 24, 2004 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? Link to comment Share on other sites More sharing options...
dbruggmann Posted June 24, 2004 Share Posted June 24, 2004 You have to enter "15:35"; if you enter "1535", Filemaker assumes that are 1535 hours. Link to comment Share on other sites More sharing options...
Lee Smith Posted June 24, 2004 Share Posted June 24, 2004 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 Link to comment Share on other sites More sharing options...
lonesomejubilee Posted June 24, 2004 Author Share Posted June 24, 2004 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? Link to comment Share on other sites More sharing options...
ESpringer Posted June 24, 2004 Share Posted June 24, 2004 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. Link to comment Share on other sites More sharing options...
lonesomejubilee Posted June 24, 2004 Author Share Posted June 24, 2004 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 Link to comment Share on other sites More sharing options...
-Queue- Posted June 24, 2004 Share Posted June 24, 2004 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. Link to comment Share on other sites More sharing options...
CobaltSky Posted June 24, 2004 Share Posted June 24, 2004 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 Link to comment Share on other sites More sharing options...
-Queue- Posted June 24, 2004 Share Posted June 24, 2004 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7105 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now