You are viewing the documentation for Blueriq 17. Documentation for other versions is available in our documentation directory.

  • Created by Unknown User (m.schadd), last modified by Unknown User (a.jansen) on Feb 23, 2021
Date patternDescription
dDisplays the day as a number without a leading zero.
ddDisplays the day as a number with a leading zero when appropriate.
MDisplays the month as a number without a leading zero.
MMDisplays the month as a number with a leading zero when appropriate.
yyDisplays the year as a two-digit number.
yyyyDisplays the year as a four-digit number.
hDisplays the hour as a number without a leading zero, based on the 12-hour clock.
HHDisplays the hour as a number with a leading zero, based on the 24-hour clock.
hhDisplays the hour as a number with a leading zero, based on the 12-hour clock.
mmDisplays the minute as a number with a leading zero.
ssDisplays the second as a number with a leading zero.
SDisplays the decisecond
SSDisplays the centisecond
SSSDisplays the millisecond
aDisplays AM for times from midnight until noon and PM for times from noon until midnight.


The following characters are allowed to be used as separators in a date pattern:


CharacterDescription
-Hyphen
,Comma
.Period
;Semicolon
:Colon

Space
/Forward slash
TTime separator
  • No labels

Didn't find the answer you were looking for? Try the advanced search!