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
The blue time should have the same value like the black one.
10:33:44 PM
10:33:44 PM
The blue time should have the PM symbol at the beginning..
10:33:44 PM
PM10:33:44
The blue time should have the PM symbol at the end as the property formula for AM/PM position returns crAMPMAfter..
10:33:44 PM
10:33:44 PM
 PM10:33:44
10:33:44 PM
The blue time should have the PM symbol at the beginning as the property formula for AM/PM position returns crAMPMBefore.
10:33:44 PM
10:33:44 PM
The blue time should have the PM symbol at the end as the property formula for AM/PM position returns AMPMAfter.
The blue time should have the PM symbol at the beginning as the property formula for AM/PM position returns AMPMBefore.
10:33:44 PM
 PM10:33:44
AM Symbol
The blue time should have the same value like the black one.
10:33:44 PM
10:33:44 PM
The blue time should have the same value like the black but the AM symbol should be a $.
10:33:44 PM
10:33:44 PM
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 §.
10:33:44 PM
10:33:44 PM
Base
The blue time should have the same value like the black one.
10:33:44 PM
10:33:44 PM
The blue time should have the value 22:33:44 as the base is set to 24h..
10:33:44 PM
22:33:44
The blue time should have the same value like the black as the property formula for base returns crTwelveHour..
10:33:44 PM
10:33:44 PM
22:33:44
10:33:44 PM
The blue time should have the value 22:33:44 as the property formula for base returns crTwentyFourHour.
10:33:44 PM
10:33:44 PM
The blue time should have the same value like the black as the property formula for base returns twelveHour.
The blue time should have the value 22:33:44 as the property formula for base returns twentyFourHour.
10:33:44 PM
22:33:44

© 2005-2024, i-net software GmbH
Page 1

Such a background indicates that the formatting of the field is done by a formula.
Hour format (Hour:Minute:Second)
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
22:33:44
The blue date should have value 34:56 as the hour should be missing.
22:33:44
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
22:33:44
The blue date should have value 34:56 as the property formula for hour format returns crNoHour.
22:33:44
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
22:33:44
The blue date should have value 34:56 as the property formula for hour format returns noHour.
22:33:44
33:44
Hour/Minute Separator
The blue time should have the same value like the black one.
10:33:44 PM
10:33:44 PM
The blue time should have the same value like the black but the hour/minute separator should be a $.
10:33:44 PM
10$33:44 PM
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 §.
10:33:44 PM
10§33:44 PM
Minute format (Hour:Minute:Second)
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:33:44
The blue date should have value 12:45 as the minute should be missing.
22:33:44
22: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:33:44
The blue date should have value 12:45 as the property formula for minute format returns crNoMinute.
22:33:44
22: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:33:44
The blue date should have value 12:45 as the property formula for minute format returns noMinute.
22:33:44
22:44

© 2005-2024, i-net software GmbH
Page 2

Such a background indicates that the formatting of the field is done by a formula.
Minute/Second Separator
The blue time should have the same value like the black one.
10:33:44 PM
10:33:44 PM
The blue time should have the same value like the black but the minute/second separator should be a $.
10:33:44 PM
10:33$44 PM
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 §.
10:33:44 PM
10:33§44 PM
PM Symbol
The blue time should have the same value like the black one.
10:33:44 PM
10:33:44 PM
The blue time should have the same value like the black but the PM symbol should be a $.
10:33:44 PM
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 §.
10:33:44 PM
10:33:44§
Second format (Hour:Minute:Second)
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:44
The blue date should have value 12:34 as the second should be missing.
22:33:44
22:33
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:44
The blue date should have value 12:34 as the property formula for second format returns crNoSecond.
22:33:44
22:33
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:44
The blue date should have value 12:34 as the property formula for second format returns noSecond.
22:33:44
22:33

© 2005-2024, i-net software GmbH
Page 3