I am attempting to use an auto enter replace existing values calculation to make entering data into a time field more efficient. I am trying to be able to enter numbers only without the and without am or pm in military time. I can enter in military time but have to use to and I am trying to skip that. So, I have develolped the following calculation but it doesn't seem to return the correct results. Can anyone find my error?

Case ( ApptTimeStart Calc ≥ 959 and ApptTimeStart Calc < 1200 ; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " am" ; ApptTimeStart Calc ≥ 1200 and ApptTimeStart Calc ≤ 1259 ; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " pm" ; ApptTimeStart Calc ≥ 1300; Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 2) & ":" & Right(Digits; 2) & " pm" ;Let (Digits = Filter(ApptTimeStart Calc; "0123456789"); Left(Digits; 1) & ":" & Right(Digits; 2) & " am"))

Paul

Hi

the "error" was to try to enter "am" or "pm" into the field.

Also( but this isn't an error )you haven't to make so many "Let"... one is enough !

Give a try to this calc:

_________________________________________________

Let([

Digits = Filter(ApptTimeStart Calc; "0123456789")

];

Case (

Length ( Digits ) = 1 ;Left(Digits; 1) & ":00" ;

Length ( Digits ) = 2 ;Left(Digits; 2) & ":00" ;

Length ( Digits ) = 3 ;Left(Digits; 1) & ":" & Right(Digits; 2) ;

Length ( Digits ) = 4 ;Left(Digits; 2) & ":" & Right(Digits; 2);

""

)

)

_________________________________________________

If you want to see the final result as:

12:23 pm you have to format, in layout mode, the field with your desired criteria in the menu Format-->Time...

Try:

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

Note:

Filemaker accepts military time entry - so there's no need to convert it to am/pm style.

Filemaker does NOT accept non-numeric characters in time fields (unless you are entering proper time, eg. "11:00 pm") - so there's no need to filter them out.

These two threads might be of interest:

http://www.fmforums.com/forum/showtopic.php?tid/163130/post/163131/#163131

http://www.fmforums.com/forum/showtopic.php?tid/149062/post/163951/#163951