Wasp Barcode WaspLabeler +2D User Manual - Manual (Page 134)

130
Wasp Labeler User Manual
Custom Date and Time Formatting (DATEFORMAT Command)
Labeler always stores date as DateTime format. This means that if you have a column in your data that
is just a date, Labeler will add the default time of 12:00:00 AM to it. If you do not want to show the time
on your label, use the DATEFORMAT function described below.
DATEFORMAT Characters and Definitions
Example DATEFORMAT Expressions
DATEFORMAT Characters and Definitions
Character Definition Additional Information Result
d
Day of the
Month
The day of the month, from 1 through 31.
9/26/2011
1:33:45 = 26
9/1/2011
1:33:45 = 1
dd
Day of the
Month
The day of the month, from 01 through 31.
9/26/2011
1:33:45 = 26
9/1/2011
1:33:45 = 01
ddd
Abbreviated
Day of
Week
The abbreviated day of the week.
9/26/2011
1:33:45 = Mon
dddd
Full Day of
Week
The full name of the day of the week.
9/26/2011
1:33:45 =
Monday
g or gg
Period or
Era
The period or era (A.D.)
9/26/2011
1:33:45 = A.D.
h Hour The hour using a 12-hour clock from 1 to 12.
9/26/2011
1:33:45 AM = 1
9/26/2011
1:33:45 PM = 1
hh Hour The hour using a 12-hour clock from 01 to 12.
9/26/2011
1:33:45 AM =
01
9/26/2011
1:33:45 PM = 01
H Hour The hour using a 24-hour lock from 0 to 23.
9/26/2011
1:33:45 AM = 1
9/26/2011