Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FieldDescription
Basic Settings
NameThe name of the Date Time Format
Date Time Format StringA string describing the format for the Date or DateTime e.g. dd/MM/yyyy or dd-MM-yy HH:mm:ss. For details of possible patterns see belowsee Date and Time Format Patterns.
Anchor
DateStyleMappings
DateStyleMappings
Date Style Mappings
Date Style Mappings can be used to provide locale provide Locale specific date formats. If a date style mapping is specified, the date format from the mapping will be used instead of the date time format string, for users with a locale that uses that date style.
Date FormatThe format for the Date or Date Time, using the patterns belowusing Date and Time Format Patterns.
Date Style NameThe Date Style this format should be applied for.
CharacterMeaningExample (2 August 2018, 16:09:22)
EDay of week as number (1-7 where Monday=1)4
EEEEDay of week, full nameThursday
dDay of month2
dd

Day of month, with leading 0 if less than 10

02
MMonth as a number8
MMMonth as a number, with leading 0 if less than 1008
MMMMonth as text, abbreviated to 3 charactersAug
MMMMMonth as text, full nameAugust
y or yyyyYear, 4 digits2018
yyYear, 2 digits18
HHour of day (0-23)16
HHHour of day (0-23), with leading 0 if less than 1016
hClock hour of half day (1-12)4
hhClock hour of half day (1-12), with leading 0 if less than 1004
mMinute9
mmMinute, with leading 0 if less than 1009
sSecond22
ssSeconds, with leading 0 if less than 1022

...

.