Help >
DDL MODE CENTURY
Version
7.11
MODE CENTURY
MODE CENTURY [OFF/number]
Allows you to control the conversion of dates with two digit years to dates with four digit years.
With MODE CENTURY OFF two digit dates are combined with the current century to produce four digit dates. For example:
On Jan 1 1999, "01/01/99" is interpreted as "01/01/1999"
On Jan 1 2000, "01/01/99" is interpreted as "01/01/2099"
With MODE CENTURY nn, two digit dates that are greater than nn are combined with 1900; those that are less than or equal to nn are combined with 2000. For example, with MODE CENTURY 15
"01/01/70" is interpreted as "01/01/1970"
"01/01/02" is interpreted as "01/01/2002"
"01/01/15" is interpreted as "01/01/2015"
"01/01/16" is interpreted as "01/01/1916"
The MODE CENTURY conversion applies to:
jdate() function with two digit year template
jdate() function with four digit year template and two digit year data
DATE fields on Data Entry Screens with two digit year template
Date fields on Screens with four digit year template and two digit year data
LOAD of a DATE field with a two digit year template
LOAD of a DATE field with four digit year template and two digit year data
FIND of a DATE field with four digit year template and two digit year data
This conversion does not apply to dates that are stored as type X fields.
Copyright © 2019 , WhamTech, Inc. All rights reserved. This
document is provided for information purposes only and the contents hereof are
subject to change without notice. Names may be
trademarks of their respective owners.