407-248-1481
QuoteWerks Knowledgebase Topic (Article ID 7082)
QuoteValet - custom date formatsThis information applies to : |
Article ID 7082 Created/Updated July 1, 2022 Category Website
|
|
| 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 |
||
|
|
©1993-2024 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)
Please Wait...