Date (DMY)
Standardization Definition
| Date (DMY) | ||
|---|---|---|
| Description |
The Date (DMY) standardization definition standardizes dates that have format DMY. The output is a zero-padded two-digit day, followed by a zero-padded two-digit month, followed by a four-digit year. The day, month, and year are separated by slashes, equal to the SAS Date format "DDMMYYS10.". |
|
| Examples | Input | Output |
| 04/07/02 | 04/07/2002 | |
| 04 JUL 05 | 04/07/2005 | |
| 04.07.05 | 04/07/2005 | |
| 4.7.05 | 04/07/2005 | |
| 4/7/2005 | 04/07/2005 | |
| 04July2005 | 04/07/2005 | |
| 04-07-2005 | 04/07/2005 | |
| 04. juillet 2005 | 04/07/2005 | |
| 04. juil. 2005 | 04/07/2005 | |
| 4. Ιούλιος 2005 | 04/07/2005 | |
| 4 luglio 2005 | 04/07/2005 | |
| 04 יולי 2005 | 04/07/2005 | |
| 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. |
||