This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

Two-digit year to four-digit year

By default, two-digit years are converted to four-digit years using a fixed, windowing technique which is heavily weighted to the last century. If the two digit year (yy) is between 00 and 09, the four digit year becomes 20yy; otherwise, it becomes 19yy.

This approach accommodates dates created by older applications, but may not be appropriate if some future date beyond 2009 was computed by the application.

Related topic

Date-support

If the default year conversion window is not acceptable, then you can specify the window conversion factor as part of the format specification. To do this, in place of yy in the format specification specify the two-digit year which determines the maximum year which is to be converted to the 21st century (20yy). Any year greater than this value will be converted to the 20th century (19yy). For information about format specifications, see Cast-data-format-specifications.

For example, the following example illustrates how you can specify that two-digit years in the range 00 to 29 are to be converted to 2000 to 2029; 30 to 99 are converted to 1930 to 1999.

Example
FIELD( (RETIREDT %29MMDD) TRANSFORM(%MMDDYYYY) )
  • RETIREDT = 171231 becomes 12312017
  • RETIREDT = 950715 becomes 07151995

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*