Properties and Formulas for Formatting Date Values
This report shows the various properties and formulas which can be used for formatting date 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.
Such a border indicates that the formatting of the field may vary on different locales.
First Date Separator
The blue date should have the same value like the black one.
06-02-01
06-02-01
The blue date should have the same value like the black but the first separator should be a $.
06-02-01
06$02-01
06-02-01
The blue date should have the same value like the black but the first separator should be a § as the property formula for the first separator sign returns §.
06§02-01
Date order
The blue date should have the same value like the black one as the date order is set to year-month-day.
06-12-31
06-12-31
The blue date should have the value 31-12-06 as the date order is set to day-month-year.
06-12-31
31-12-06
The blue date should have the value 12-31-06 as the date order is set to month-day-year.
06-12-31
12-31-06
The blue date should have the same value like the black one as property formula for date order returns crYearMonthDay.
06-12-31
06-12-31
The blue date should have the  value 31-12-06 as property formula for date order returns crDayMonthYear.
06-12-31
31-12-06
The blue date should have the value 12-31-06 as property formula for date order returns crMonthDayYear.
06-12-31
12-31-06
06-12-31
06-12-31
The blue date should have the same value like the black one as property formula for date order returns yearMonthDay.
31-12-06
06-12-31
The blue date should have the value 31-12-06 as property formula for date order returns dayMonthYear.
12-31-06
06-12-31
The blue date should have the value 12-31-06 as property formula for date order returns monthDayYear.
Date Prefix
06-02-01
06-02-01
The blue date should have the same value like the black one.
06-02-01
The blue date should have the same value like the black one with a prefix $.
$06-02-01
The blue date should have the same value like the black one with a prefix § as the property formula for date prefix returns §.
06-02-01
§06-02-01
06-02-01
06-02-01
The blue date should have the same value like the black one.

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

Second Date Separator
The blue date should have the same value like the black one.
06-02-01
06-02-01
06-02-01
The blue date should have the same value like the black but the second separator should be a $.
06-02$01
06-02-01
The blue date should have the same value like the black but the second separator should be a § as the property formula for the second separator sign returns §.
06-02§01

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

Date Suffix
The blue date should have the same value like the black one.
06-02-01
06-02-01
06-02-01
The blue date should have the same value like the black one with a suffix $.
06-02-01$
06-02-01
The blue date should have the same value like the black one with a suffix § as the property formula for date suffix returns §.
06-02-01§

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

Day format (Year-Month-Day)
06-02-01
06-02-01
The blue date should have the same value like the black one.
06-02-01
06-02-1
The blue date should have value 06-02-1 as the leading zero of the day should be missing.
The blue date should have value 06-02 as the day should be missing.
06-02-01
06-02
06-02-01
06-02-01
The blue date should have the same value like the black one as the property formula for day format returns crLeadingZeroDay.
06-02-01
06-02-1
The blue date should have value 06-02-1 as the property formula for day format returns crNumericDay.
The blue date should have the value 06-02 as the property formula for day format returns crNoDay..
06-02-01
06-02
06-02-01
06-02-01
The blue date should have the same value like the black one as the property formula for day format returns leadingZeroDay.
06-02-01
06-02-1
The blue date should have value 06-02-1 as the property formula for day format returns numericDay.
06-02
06-02-01
The blue date should have the value 06-02 as the property formula for day format returns noDay.

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

Day of week brackets
06-02-01
Wed06-02-01
The blue date should have the same value like the black one with the week day name as prefix.
06-02-01
The week day name of the blue date should be enclosed by parentheses.
(Wed)06-02-01
The week day name of the blue date should be enclosed by angle brackets.
06-02-01
<Wed>06-02-01
06-02-01
The week day name of the blue date should be enclosed by square brackets
[Wed]06-02-01
The week day name of the blue date should hav no enclosing as the property formula for day of week brackets returns crDayOfWeekNotEnclosed.
06-02-01
Wed06-02-01
06-02-01
The week day name of the blue date should be enclosed by parantheses as the property formula for day of week brackets returns crDayOfWeekInParentheses ..
(Wed)06-02-01
06-02-01
The week day name of the blue date should be enclosed by angle brackets as the property formula for day of week type returns crDayofWeekInFWParentheses(angle brackets in CC).
<Wed>06-02-01
06-02-01
The week day name of the blue date should be enclosed by square brackets as the property formula for day of week brackets returns crDayOfWeekInSquareBrackets.
[Wed]06-02-01
06-02-01
The week day name of the blue date should hav no enclosing as the property formula for day of week brackets returns dayOfWeekNotEnclosed.
Wed06-02-01
(Wed)06-02-01
06-02-01
The week day name of the blue date should be enclosed by parantheses as the property formula for day of week brackets returns dayOfWeekInFWParentheses (angle brackets in CC).
<Wed>06-02-01
06-02-01
The week day name of the blue date should be enclosed by angle brackets as the property formula for day of week type returns dayOfWeekInFWParentheses.
[Wed]06-02-01
06-02-01
The week day name of the blue date should be enclosed by square brackets as the property formula for day of week brackets returns dayOfWeekInSquareBrackets.

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

Day of week position
06-02-01
Wed06-02-01
The blue date should have a leading day of week name.
06-02-01
The blue date should have a trailing day of week name.
06-02-01Wed
06-02-01
The blue date should have a leading day of week name as the property formula for day of week position returns crLeadingDayOfWeek.
Wed06-02-01
The blue date should have a trailing day of week name as the property formula for day of week position returns crTrailingDayOfWeek.
06-02-01
06-02-01Wed
Wed06-02-01
The blue date should have a leading day of week name as the property formula for day of week position returns leadingDayOfWeek.
06-02-01
06-02-01Wed
The blue date should have a trailing day of week name as the property formula for day of week position returns trailingDayOfWeek.
06-02-01

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

Day of week separator
06-02-01
Wed06-02-01
The blue date should have a leading day of week name.
06-02-01
The blue date should have a leading day of week name with a $ as separator sign.
Wed$06-02-01
06-02-01
The blue date should have a leading day of week name with a § as separator sign as the property formula for day of week separator returns §.
Wed§06-02-01

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

Day of week type
06-02-01
06-02-01
The blue date should have the same value like the black one.
06-02-01
The blue date should have the same value like the black one with a prefix Wed for the short day of week name
Wed06-02-01
The blue date should have the same value like the black one with a prefix Wednedsay for the long day of week name
06-02-01
Wednesday06-02-01
06-02-01
The blue date should have the same value like the black one as the property formula for day of week type returns crNoDayOfWeek.
06-02-01
The blue date should have the same value like the black one with a prefix Wed as the property formula for day of week type returns crShortDayOfWeek.
06-02-01
Wed06-02-01
06-02-01
The blue date should have the same value like the black one with a prefix Wednedsay as the property formula for day of week type returns crLongDayOfWeek.
Wednesday06-02-01
06-02-01
The blue date should have the same value like the black one as the property formula for day of week type returns noDayOfWeek.
06-02-01
Wed06-02-01
06-02-01
The blue date should have the same value like the black one with a prefix Wed as the property formula for day of week type returns shortDayOfWeek.
Wednesday06-02-01
06-02-01
The blue date should have the same value like the black one with a prefix Wednesday as the property formula for day of week type returns longDayOfWeek.

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

Month format (Year-Month-Day)
06-02-01
06-02-01
The blue date should have the same value like the black one.
06-02-01
The blue date should have value 06-2-01 as the leading zero of the month should be missing.
06-2-01
The blue date should have value 06-February-01 or a translated version.
06-02-01
06-February-01
06-02-01
The blue date should have value 06-Feb-01 or a translated version.
06-Feb-01
06-02-01
The blue date should have value 06-01 as the month should be missing.
06-01
The blue date should have the same value like the black one as the property formula for month format returns crLeadingZeroMonth.
06-02-01
06-02-01
06-2-01
06-02-01
The blue date should have value 06-2-01 as the property formula for month format returns crNumericMonth.
06-February-01
06-02-01
The blue date should have value 06-February-01 as the property formula for month format returns crLongMonth.
06-Feb-01
06-02-01
The blue date should have value 06-Feb-01 as the property formula for month format returns crShortMonth.
06-01
06-02-01
The blue date should have value 06-01 as the property formula for month format returns crNoMonth.
06-02-01
06-02-01
The blue date should have the same value like the black one as the property formula for month format returns leadingZeroMonth.
06-2-01
06-02-01
The blue date should have value 06-2-01 as the property formula for month format returns numericMonth.
06-February-01
06-02-01
The blue date should have value 06-February-01 as the property formula for month format returns longMonth.
06-Feb-01
06-02-01
The blue date should have value 06-Feb-01 as the property formula for month format returns shortMonth.
06-01
06-02-01
The blue date should have value 06-01 as the property formula for month format returns noMonth.

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

Year format (Year-Month-Day)
06-02-01
06-02-01
The blue date should have the same value like the black one.
06-02-01
The blue date should have value 2006-02-01 as there should be a long year format.
2006-02-01
The blue date should have value 02-01 as the year should be missing.
06-02-01
02-01
06-02-01
The blue date should have the same value like the black one as the property formula for year format returns crShortYear.
06-02-01
06-02-01
The blue date should have value 2006-02-01 as the property formula for year format returns crLongYear.
2006-02-01
The blue date should have the value 02-01 as the property formula for year format returns crNoYear..
06-02-01
02-01
06-02-01
The blue date should have the same value like the black one as the property formula for year format returns shortYear.
06-02-01
06-02-01
The blue date should have value 2006-02-01 as the property formula for year format returns longYear.
2006-02-01
06-02-01
The blue date should have the value 02-01 as the property formula for year format returns noYear.
02-01

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