Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Date and Time Format Strings
Functions and Expressions Reference Guide
243
Japanese Date Format Strings
Sub-String Name Sub-String Value
Japanese Date
Year + MonthSet(1)
Year
CCYY
YY
EEYY
EY
MonthSet
Separator(1) + "MM" + DayOfMonth(1)
"[" + Separator(1) + "MM" + DayOfMonth(1) + ″]″
Separator(1) + ″M″ + DayOfMonth(1)
″[″ + Separator(1) + ″M″ + DayOfMonth(1) + ″]″
DayOfMonth
Separator(1) + "DD" + WeekDay(1)
"[" + Separator(1) + "DD" + WeekDay(1) + "]"
Separator(1) + "D" + WeekDay(1)
"[" + Separator(1) + "D" + WeekDay(1) + "]"
WeekDay
Separator(1) + "DY"
"[" + Separator(1) + "DY" + "]"
Separator(1) + "DAY"
"[" + Separator(1) + "DAY" + "]"
Separator Separator is optional. If specified, it can be up to 120 bytes
composed of non-alphabetic characters. Symbol table values,
such as <CR>, can be used to indicate non-printable
characters.
MonthSet Separator required if Year is EY
DayOfMonth Separator required if MonthSet is M
WeekDay Separator required if DayOfMonth is D