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

AQ_DatePattern


Use this mask type to change the way a date or dateTime value is displayed in Blueriq Studio documents.


Parameters

NameDescriptionTypeRequired
date patterna pattern composed of date pattern options and separatorsstringtrue


To define your own date mask you must compose a date pattern using the following options:

Date patternDescription
dDisplays the day as a number without a leading zero.
ddDisplays the day as a number with a leading zero when appropriate.
dayDisplays the day as a number written in words (“one” to “thirty one”).
dayofweekDisplays the day as a full name (“Sunday” to “Saturday”).
MDisplays the month as a number without a leading zero.
MMDisplays the month as a number with a leading zero when appropriate.
monthDisplays the month as a full name (“January” to “December”).
shortmonthDisplays the month as an abbreviation (“Jan to Dec”).
yyDisplays the year as a two-digit number.
yyyyDisplays the year as a four-digit number.
yearDisplays the year as a number written in words (e.g. “two thousand and nine”)
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.
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


Supported attribute types

  • date

  • dateTime


Supported languages

  • Dutch

  • English

Which language will be used to display weekdays, days, months or years in words is determined by the language in which you specified your document.


Examples

To displayasuse this pattern
12-02-2009Thursday 12 Feb. 09dayofweek dd shortmonth yy
12-02-2009 13:12Thursday 1:12 AMdayofweek h:mm a
12-02-20092009yyyy
12-02-2009February 12 two thousand and ninemonth dd year
12-02-200912/02/2009dd/MM/yyyy

Back to Top