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 │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 06-02-01 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 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 §. ────────────────────────────────────────────────────────────────────────────────────── │ Date order │ ────────────────────────────────────────────────────────────────────────────────────── 06-12-31 06-12-31 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 31-12-06 The blue date should have the value 31-12-06 as the date ───────────────────────────────────────────────────────────────────────────────────── order is set to day-month-year. 06-12-31 12-31-06 The blue date should have the value 12-31-06 as the date ───────────────────────────────────────────────────────────────────────────────────── order is set to month-day-year. 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 ───────────────────────────────────────────────────────────────────────────────────── crYearMonthDay. 06-12-31 31-12-06 The blue date should have the value 31-12-06 as property ───────────────────────────────────────────────────────────────────────────────────── formula for date order returns crDayMonthYear. 06-12-31 12-31-06 The blue date should have the value 12-31-06 as property ───────────────────────────────────────────────────────────────────────────────────── formula for date order returns crMonthDayYear. 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. 06-12-31 31-12-06 The blue date should have the value 31-12-06 as property ───────────────────────────────────────────────────────────────────────────────────── formula for date order returns dayMonthYear. 06-12-31 12-31-06 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 $06-02-01 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one with a prefix $. 06-02-01 §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 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. Page 1 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── Second Date Separator │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 06-02-01 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 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 §. Page 2 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── Date Suffix │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 06-02-01 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 ───────────────────────────────────────────────────────────────────────────────────── 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 §. Page 3 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │Day format (Year-Month │ ───────────────────────────────────────────────────────────────────────────────────── 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. 06-02-01 06-02 The blue date should have value 06-02 as the day should ───────────────────────────────────────────────────────────────────────────────────── be missing. 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. 06-02-01 06-02 The blue date should have the value 06-02 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for day format returns crNoDay.. 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-01 06-02 The blue date should have the value 06-02 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for day format returns noDay. Page 4 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │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 (Wed)06-02-01 The week day name of the blue date should be enclosed ───────────────────────────────────────────────────────────────────────────────────── by parentheses. 06-02-01 06-02-01 The week day name of the blue date should be enclosed ───────────────────────────────────────────────────────────────────────────────────── by angle brackets. 06-02-01 [Wed]06-02-01 The week day name of the blue date should be enclosed ───────────────────────────────────────────────────────────────────────────────────── by square brackets 06-02-01 Wed06-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 (Wed)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 .. 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). 06-02-01 [Wed]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. 06-02-01 Wed06-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. (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). 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. Page 5 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │Day of week position │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 Wed06-02-01 The blue date should have a leading day of week name. ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 06-02-01Wed The blue date should have a trailing day of week name. ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 Wed06-02-01 The blue date should have a leading day of week name as the property formula for day of week position returns ───────────────────────────────────────────────────────────────────────────────────── crLeadingDayOfWeek. 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 crTrailingDayOfWeek. 06-02-01 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. Page 6 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │Day of week separator │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 Wed06-02-01 The blue date should have a leading day of week name. ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 Wed$06-02-01 The blue date should have a leading day of week name ───────────────────────────────────────────────────────────────────────────────────── with a $ as separator sign. 06-02-01 Wed§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 §. Page 7 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │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 Wed06-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 06-02-01 Wednesday06-02- 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 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 Wed06-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 Wednesday06-02- 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. 06-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 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. 06-02-01 Wednesday06-02- 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. Page 8 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │Month format (Year-Mon │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 06-02-01 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 06-02-01 06-2-01 The blue date should have value 06-2-01 as the leading ───────────────────────────────────────────────────────────────────────────────────── zero of the month should be missing. 06-02-01 06-February The blue date should have value 06-February-01 or a ───────────────────────────────────────────────────────────────────────────────────── translated version. 06-02-01 06-Feb-01 The blue date should have value 06-Feb-01 or a translated ───────────────────────────────────────────────────────────────────────────────────── version. 06-02-01 06-01 The blue date should have value 06-01 as the month should ───────────────────────────────────────────────────────────────────────────────────── be missing. 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 ───────────────────────────────────────────────────────────────────────────────────── crLeadingZeroMonth. 06-02-01 06-2-01 The blue date should have value 06-2-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for month format returns crNumericMonth. 06-02-01 06-February The blue date should have value 06-February-01 as the ───────────────────────────────────────────────────────────────────────────────────── property formula for month format returns crLongMonth. 06-02-01 06-Feb-01 The blue date should have value 06-Feb-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for month format returns crShortMonth. 06-02-01 06-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-02-01 06-2-01 The blue date should have value 06-2-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for month format returns numericMonth. 06-02-01 06-February The blue date should have value 06-February-01 as the ───────────────────────────────────────────────────────────────────────────────────── property formula for month format returns longMonth. 06-02-01 06-Feb-01 The blue date should have value 06-Feb-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for month format returns shortMonth. 06-02-01 06-01 The blue date should have value 06-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for month format returns noMonth. Page 9 © 2005-2024, i-net software ============================================================================================== ───────────────────────────────────────────────────────────────────────────────────── │Year format (Year-Mont │ ───────────────────────────────────────────────────────────────────────────────────── 06-02-01 06-02-01 The blue date should have the same value like the black ───────────────────────────────────────────────────────────────────────────────────── one. 06-02-01 2006-02-01 The blue date should have value 2006-02-01 as there ───────────────────────────────────────────────────────────────────────────────────── should be a long year format. 06-02-01 02-01 The blue date should have value 02-01 as the year should ───────────────────────────────────────────────────────────────────────────────────── be missing. 06-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 2006-02-01 The blue date should have value 2006-02-01 as the ───────────────────────────────────────────────────────────────────────────────────── property formula for year format returns crLongYear. 06-02-01 02-01 The blue date should have the value 02-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for year format returns crNoYear.. 06-02-01 The blue date should have the same value like the black 06-02-01 one as the property formula for year format returns ───────────────────────────────────────────────────────────────────────────────────── shortYear. 06-02-01 2006-02-01 The blue date should have value 2006-02-01 as the ───────────────────────────────────────────────────────────────────────────────────── property formula for year format returns longYear. 06-02-01 02-01 The blue date should have the value 02-01 as the property ───────────────────────────────────────────────────────────────────────────────────── formula for year format returns noYear. Page 10 © 2005-2024, i-net software