Date (MDY)
Standardization Definition
| Date (MDY) | ||
|---|---|---|
| Description |
The Date (MDY) standardization definition standardizes dates that have format MDY. The output is a zero-padded two-digit month, followed by a zero-padded two-digit day, followed by a four-digit year. The month, day, and year are separated by slashes, equal to the SAS Date format "MMDDYYS10.". |
|
| Examples | Input | Output |
| 07/04/02 | 07/04/2002 | |
| JUL 04 05 | 07/04/2005 | |
| 07.04.05 | 07/04/2005 | |
| 7.4.05 | 07/04/2005 | |
| 7/4/2005 | 07/04/2005 | |
| July042005 | 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 | |
| יולי 4 2005 | 07/04/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. |
||