KBA-01131: Formatting the Date in Doc Templates

Question:

When I create a Bookmark Template, how can I specify the format for the date fields?

Answer:

Using a prefix with your bookmark will specify the format for your data. Below are some examples:

Bookmark Result in Document Template
DocHeader_Due Wednesday, July 6, 2005 5:00 pm
FS_DocHeader_Due 7/6/2005 5:00 pm
Fd_DocHeader_Due 7/6/2005
FD_DocHeader_Due Wednesday, July 6, 2005
FG_DocHeader_Due 7/6/2005 5:00 PM
FM_DocHeader_Due July 06
FY_DocHeader_Due July 2005

Spitfire will even support custom date formats. Below are the custom characters we support:

Format Pattern Description
b………………………..

c………………………..

blank

, (comma)

X……………………….. The default time separator
x (lower case)………… The default date separator
Date Formats:
d……………………….. The day of the month. Single-digit days will not have a leading zero.
dd……………………… The day of the month. Single-digit days will have a leading zero.
ddd…………………….. The abbreviated name of the day of the week.
dddd…………………… The full name of the day of the week.
M………………………. The numeric month. Single-digit months will not have a leading zero.
MM…………………….. The numeric month. Single-digit months will have a leading zero.
MMM…………………… The abbreviated name of the month.
MMMM…………………. The full name of the month.
yy……………………… The year without the century. If the year without the century is less than 10, the year is displayed with a leading zero.
yyyy…………………… The year in four digits, including the century.
Time Formats:
h……………………….. The hour in a 12-hour clock. Single-digit hours will not have a leading zero.
hh……………………… The hour in a 12-hour clock. Single-digit hours will have a leading zero.
H……………………….. The hour in a 24-hour clock. Single-digit hours will not have a leading zero.
HH……………………… The hour in a 24-hour clock. Single-digit hours will have a leading zero.
m………………………. The minute. Single-digit minutes will not have a leading zero.
mm…………………….. The minute. Single-digit minutes will have a leading zero.
t……………………….. The first character in the AM/PM designator.
tt………………………. The AM/PM designator.

To use a custom format, add it to your bookmark prefix. For example:

FddxMMxyy_DocHeader_Due would print 07/06/05

FddxMMxyyyybhhXmmbtt_DocHeader_Due would print 07/06/2005 05:00 PM

Additional Comments:

See also KBA-01132. For more information about this and other bookmark names, see the Focus on Bookmark Templates guide.


KBA-01131; Last updated: October 12, 2016 at 11:28 am;
Keywords:  bookmarks, Doc Template, bookmarks