407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 7082)

QuoteValet - custom date formats

This information applies to :

Article ID
7082

Created/Updated
July 1, 2022

Category
Website


Are you using the most current release of QuoteWerks?
Version 23.0 Build 1
Regarding date formatting, the QV_ExpirationDate is preformatted utilizing United States Date Format, however any DH_* date fields are left completely unformatted and it's up to the template to specify formatting. The formatting for the QV_Expiration date can overridden simply by applying formatting macro attributes of :DateFormatString=


For example:
[QV_CommentDateTime:DateFormatString=dd/MM/yyyy]
[DH_ContractStartDate:DateFormatString=dd/MM/yyyy]
[DH_ContractEndDate:DateFormatString=dd/MM/yyyy]
[DH_ExpirationDate:DateFormatString=dddd dd MMMM yyyy]
[DH_DocDate:DateFormatString=ddd dd MMM yyyy]


Be cautious with any special characters when specifying date format. For example, a comma in the expiration date example after the dddd will cause the template to break. Best practice is to use / or avoid special characters.

Custom Format Examples List:

DayFormat ValueSample header

d day of the month 1 – 31
dd day of the month 01 – 31
ddd abbreviated name of the day of the week (Mon, Tues, Wed etc)

dddd Full name of the day of the week (Monday, Tuesday etc)

h 12-hour clock hour (e.g. 9)
hh 12-hour clock, with a leading 0 (e.g. 09)
H 24-hour clock hour (e.g. 19)
HH 24-hour clock hour, with a leading 0 (e.g. 19)

t Abbreviated AM / PM (e.g. A or P)
tt AM / PM
y Year. eg. 2009 become 9
yy Year. eg. 2009 become 09
yyy Year. 2009
yyyy Year. 2009
K Represents the time zone information eg. +6:00

ss Seconds with leading zero
m Minutes
mm Minutes with a leading zero

M Month number 1-12
MM Month number with leading zero 01-12
MMM Abbreviated Month Name (Jan, Feb)
MMMM Full month name (January)
s Seconds
ss Seconds with leading zero

New Search