Date (YMD)
Standardization Definition
| Date (YMD) | ||
|---|---|---|
| Description |
The Date (YMD) standardization definition standardizes dates that have format YMD. The output is a four-digit year, followed by a zero-padded two-digit month, followed by a zero-padded two-digit day. The year, month, and day are separated by slashes, eqal to the SAS Date format "YYMMDDS10.". |
|
| Examples | Input | Output |
| 02/07/04 | 2002/07/04 | |
| 05 JUL 04 | 2005/07/04 | |
| 05.07.04 | 2005/07/04 | |
| 05.7.4 | 2005/07/04 | |
| 2005/7/4 | 2005/07/04 | |
| 2005July04 | 2005/07/04 | |
| 2005-07-04 | 2005/07/04 | |
| 2005 juillet 04 | 2005/07/04 | |
| 2005 juil. 04. | 2005/07/04 | |
| 2005 Ιούλιος 4. | 2005/07/04 | |
| 2005 luglio 4 | 2005/07/04 | |
| 2005 יולי 04 | 2005/07/04 | |
| Remarks | If the input year is a two-digit value, it is assumed to be within the hundred year span with 2049 as the end of the span. For example, a year of 49 will be 2049, but a year of 50 will be 1950. | |
|
If this definition is applied to preparsed data, the following input tokens are available:
It is recommended that you map a correlating data field to each available token whenever possible. |
||