IBM PureData System for Analytics, Version 7.1

The DateStyle option

Specifies how to interpret the date format.

The possible values for the DateStyle option are shown in the following table. The example shows how the date 21 March 2014 would be represented without a date delimiter.

Table 1. DateStyle
Value	Description	Example
YMD	4-digit year, 2-digit month, 2-digit day. This is the default.	20140321
DMY	2-digit day, 2-digit month, 4-digit year.	21032014
MDY	2-digit month, 2-digit day, 4-digit year.	03212014
MONDY	3-character month, 2-digit day, 4-digit year.	Mar212014
DMONY	2-digit day, 3-character month, 4-digit year.	21Mar2014
Y2MD	2-digit year, 2-digit month, 2-digit day. Not supported for unloads.	140321
DMY2	2-digit day, 2-digit month, 2-digit year. Not supported for unloads.	210314
MDY2	2-digit month, 2-digit day, 2-digit year. Not supported for unloads.	032114
MONDY2	3-character month, 2-digit day, 2-digit year. Not supported for unloads.	Mar2114
DMONY2	2-digit day, 3-character month, 2-digit year. Not supported for unloads.	21Mar14

The 4-digit years are in the range 0001 - 9999. There is no provision for years before 0001 CE or after 9999 CE.

For example:

In a control file, to specify the date format MM-DD-YY (for example, 03-21-14), set datestyle to MDY2 and datedelim to '-'.
In the command line, if the data file jan-01.data contains records in the following format (the date format is shown in bold):
```
14255932|30/06/2002|20238|20127|40662|157|
```
because the date value uses the DD/MM/YYYY format, load that file by specifying the following nzload command:
```
nzload -t agg_month -df jan-01.data -delim '|' -dateStyle DMY -dateDelim '/'
```