Source Data Identifier - Date Processing Options
Processing options differ depending on the type of data element you created.
Date processing options include date format and value alignment. Value alignment specifies how values are aligned and filled when the source field is a fixed length character field. The first option is the default.
If the source date field includes a timestamp, then complete Java Date/Timestamp format must be represented. However, date processing will occur only on the Date portion of the field.
Date Format options include:
- Default date format specified in the Data Element (default)
- Specify date format. Select Specify date format if the format of the date in the field identified by this SDI is different than the default date format specified in the data element. Only use this option when the metadata does not include the data format. If you choose this option, select a date format from the list, or enter the date format you wish to use.
Java “SimpleDateFormat” pattern letters include the following letters. Keep in mind that uppercase and lowercase letters refer to different date parts.
Letter | Date Component | Output | Examples |
|---|---|---|---|
y | year | Year | 1996; 96 |
M | month in year | Month | July, Jul, 07 |
w | week in year | Number | 27 |
W | week in month | Number | 2 |
D | day in year | Number | 189 |
d | day in month | Number | 10 |
F | day of week in month | Number | 2 |
E | day in week | Text | Tuesday, Tue |
Value Alignment options include:
- Use the options specified in the Data Element (default)
- Left justify and blank fill
Right justify and blank fill