Properties and Formulas for Formatting Time Values This report shows the various properties and formulas which can be used for formatting time values. Custom formatting is possible instead of using the system default format. Such a background indicates that the formatting of the field is done by a formula. ───────────────────────────────────────────────────────────────────────────────────── │AM/PM Position │ ───────────────────────────────────────────────────────────────────────────────────── 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 10:33:44 P PM10:33:44 The blue time should have the PM symbol at the beginning. ───────────────────────────────────────────────────────────────────────────────────── . 10:33:44 P 10:33:44 P The blue time should have the PM symbol at the end as the ───────────────────────────────────────────────────────────────────────────────────── property formula for AM/PM position returns crAMPMAfter.. 10:33:44 P PM10:33:4 The blue time should have the PM symbol at the beginning as the property formula for AM/PM position returns ───────────────────────────────────────────────────────────────────────────────────── crAMPMBefore. 10:33:44 P 10:33:44 P The blue time should have the PM symbol at the end as the ───────────────────────────────────────────────────────────────────────────────────── property formula for AM/PM position returns AMPMAfter. 10:33:44 P PM10:33:4 The blue time should have the PM symbol at the beginning as the property formula for AM/PM position returns ───────────────────────────────────────────────────────────────────────────────────── AMPMBefore. ───────────────────────────────────────────────────────────────────────────────────── AM Symbol │ ───────────────────────────────────────────────────────────────────────────────────── 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── but the AM symbol should be a $. 10:33:44 P 10:33:44 P The blue time should have the same value like the black but the AM symbol should be a § as the property formula ───────────────────────────────────────────────────────────────────────────────────── for the AM symbol returns §. ───────────────────────────────────────────────────────────────────────────────────── │Base │ ───────────────────────────────────────────────────────────────────────────────────── 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 10:33:44 P 22:33:44 The blue time should have the value 22:33:44 as the base ───────────────────────────────────────────────────────────────────────────────────── is set to 24h.. 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── as the property formula for base returns crTwelveHour.. 10:33:44 P 22:33:44 The blue time should have the value 22:33:44 as the ───────────────────────────────────────────────────────────────────────────────────── property formula for base returns crTwentyFourHour. 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── as the property formula for base returns twelveHour. 10:33:44 P 22:33:44 The blue time should have the value 22:33:44 as the ───────────────────────────────────────────────────────────────────────────────────── property formula for base returns twentyFourHour. Page 1 © 2005-2024, i-net software ============================================================================================== Such a background indicates that the formatting of the field is done by a formula. ───────────────────────────────────────────────────────────────────────────────────── │Hour format (Hour:Minute:Second) │ ───────────────────────────────────────────────────────────────────────────────────── 22:33:44 22:33:44 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 22:33:44 22:33:44 The blue date should have value 2:34:56 as the leading ───────────────────────────────────────────────────────────────────────────────────── zero of the hour should be missing. 22:33:44 33:44 The blue date should have value 34:56 as the hour should ───────────────────────────────────────────────────────────────────────────────────── be missing. 22:33:44 22:33:44 The blue date should have the same value like the black one as the property formula for hour format returns ───────────────────────────────────────────────────────────────────────────────────── crLeadingZeroHour. 22:33:44 22:33:44 The blue date should have value 2:34:56 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for hour format returns crNumericHour. 22:33:44 33:44 The blue date should have value 34:56 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for hour format returns crNoHour. 22:33:44 22:33:44 The blue date should have the same value like the black one as the property formula for hour format returns ───────────────────────────────────────────────────────────────────────────────────── leadingZeroHour. 22:33:44 22:33:44 The blue date should have value 2:34:56 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for hour format returns numericHour. 22:33:44 33:44 The blue date should have value 34:56 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for hour format returns noHour. ───────────────────────────────────────────────────────────────────────────────────── Hour/Minute Separator │ ───────────────────────────────────────────────────────────────────────────────────── 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 10:33:44 P 10$33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── but the hour/minute separator should be a $. 10:33:44 P 10§33:44 P The blue time should have the same value like the black but the hour/minute separator should be a § as the property formula for the hour/minute separator sign ───────────────────────────────────────────────────────────────────────────────────── returns §. ───────────────────────────────────────────────────────────────────────────────────── │Minute format (Hour:Minute:Second) │ ───────────────────────────────────────────────────────────────────────────────────── 22:33:44 22:33:44 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 22:33:44 22:33:44 The blue date should have value 12:3:45 as the leading ───────────────────────────────────────────────────────────────────────────────────── zero of the minute should be missing. 22:33:44 22:44 The blue date should have value 12:45 as the minute ───────────────────────────────────────────────────────────────────────────────────── should be missing. 22:33:44 22:33:44 The blue date should have the same value like the black one as the property formula for minute format returns ───────────────────────────────────────────────────────────────────────────────────── crLeadingZeroMinute. 22:33:44 22:33:44 The blue date should have value 12:3:45 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for minute format returns crNumericMinute. 22:33:44 22:44 The blue date should have value 12:45 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for minute format returns crNoMinute. 22:33:44 22:33:44 The blue date should have the same value like the black one as the property formula for minute format returns ───────────────────────────────────────────────────────────────────────────────────── leadingZeroMinute. 22:33:44 22:33:44 The blue date should have value 12:3:45 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for minute format returns numericMinute. 22:33:44 22:44 The blue date should have value 12:45 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for minute format returns noMinute. Page 2 © 2005-2024, i-net software ============================================================================================== Such a background indicates that the formatting of the field is done by a formula. ───────────────────────────────────────────────────────────────────────────────────── Minute/Second Separato │ ───────────────────────────────────────────────────────────────────────────────────── 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 10:33:44 P 10:33$44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── but the minute/second separator should be a $. 10:33:44 P 10:33§44 P The blue time should have the same value like the black but the minute/second separator should be a § as the property formula for the minute/second separator sign ───────────────────────────────────────────────────────────────────────────────────── returns §. ───────────────────────────────────────────────────────────────────────────────────── PM Symbol │ ───────────────────────────────────────────────────────────────────────────────────── 10:33:44 P 10:33:44 P The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 10:33:44 P 10:33:44$ The blue time should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── but the PM symbol should be a $. 10:33:44 P 10:33:44§ The blue time should have the same value like the black but the PM symbol should be a § as the property formula ───────────────────────────────────────────────────────────────────────────────────── for the PM symbol returns §. ───────────────────────────────────────────────────────────────────────────────────── │Second format (Hour:Minute:Second) │ ───────────────────────────────────────────────────────────────────────────────────── 22:33:44 22:33:44 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 22:33:44 22:33:44 The blue date should have value 12:34:5 as the leading ───────────────────────────────────────────────────────────────────────────────────── zero of the second should be missing. 22:33:44 22:33 The blue date should have value 12:34 as the second ───────────────────────────────────────────────────────────────────────────────────── should be missing. 22:33:44 22:33:44 The blue date should have the same value like the black one as the property formula for second format returns ───────────────────────────────────────────────────────────────────────────────────── crLeadingZeroSecond. 22:33:44 22:33:44 The blue date should have value 12:34:5 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for second format returns crNumericSecond. 22:33:44 22:33 The blue date should have value 12:34 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for second format returns crNoSecond. 22:33:44 22:33:44 The blue date should have the same value like the black one as the property formula for second format returns ───────────────────────────────────────────────────────────────────────────────────── leadingZeroSecond. 22:33:44 22:33:44 The blue date should have value 12:34:5 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for second format returns numericSecond. 22:33:44 22:33 The blue date should have value 12:34 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for second format returns noSecond. Page 3 © 2005-2024, i-net software