Was this helpful?
Setting Up Picture Masks
The Picture Mask option designates special data formatting, such as how Date, Time, Date/Time, and Boolean values are stored in your source data file or table.
Formatting Boolean Data
The following table contains examples of Boolean picture masks.
Note:  The Boolean picture masks are case-insensitive.
 
Boolean Picture Example
Description
True.False
Returns a true or false value
Yes.No
Returns a yes or no value
Formatting Date/Time Data
The following table lists the date and time value placeholders, called tokens, that you can combine to create date/time picture masks in DataConnect.
Note:  Most of the tokens are case-sensitive. For example, use "mm" for months and "MM" for minutes.
 
Date/Time Token Name
Description
d
Day of the month (1 - 31)
dd
Day of the month (two digits, 01 - 31)
ddd
Day of the year (001-365, 001-366 for a leap year)
m
Month of the year (1 - 12)
mm
Month of the year (two digits, 01 - 12)
mon
Abbreviated name of month
month
Full name of month
yy
Year, last two digits (00 - 99)
Equivalent to YY2000 (the century split is assumed to be 2000).
YYxxxx
Two-digit year with base century and century split to be automatically applied.
The "xxxx" represents the base century (right-most two digits) and the century split (left-most two digits).
yyyy
Year (four digits)
HH
Time of day, 12-hour clock (1-12)
H24
TIme of day, military 24-hour clock (two digits, 00 - 23)
MM
Minutes (two digits, 00 - 59)
SS
Seconds (two digits, 00 - 59)
TTx
Fraction of a second. The "x" represents the number of digits. If missing, a value of 3 is used.
Am
Time of day, not case-sensitive. For example, AM, am, PM, and pm.
Must be preceded by HH, MM, or SS.
Last modified date: 08/02/2023