Year stored is wrong while uploading data from CSV into IRIS

There are provisions in the $ZDATEH function to cover the "two-digit-year" century issue. If you need all two-digit years to equate to 20xx, try this:

$ZDATEH("01/01/23",,,3,58074,94598)

As in, set the 'yearopt' parameter to 3, then set the startwin & endwin dates (in $H format) to the beginning and ending window to interpret the two-digit years.

If you need a specific range 100 year range - for this example, to evaluate two-digit years between 01/01/1950 and 12/31/2049, you'll need the $H values of those dates:

W $ZDATEH("1/1/1950")
39812
W $ZDATEH("12/31/2049")
76336

Then use those $H values in the window of the $ZDATEH command:

$ZDATEH("01/01/23",,,3,39812,76336)

Here's more documentation on the $ZDATEH command:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fzdateh

Hope this helps!

The reason behind the conversion is Cache identifies/assume from 1900 - 1999 year if you send two digit for year. So, You should send four digit year. attached the documentation "Two or four digits may be specified for years in the range 1900 to 1999. Four digits must be specified for years before 1900 or after 1999."

Hi @Anup Thakkar,

the simplest way to always stay in the current century is : 

$ZDATEH("05/26/23",,,6)

You just need to use year-opt = 6 to get all dates with two-digit years in the current century .

w $zdt($ZDATEH("05/26/23",,,6),3)
2023-05-26

w $zdt($ZDATEH("05/26/1923",,,6),3)
1923-05-26