Elliott Date Century Cutoff - Why Does Year 31 Become 1931?

Elliott Date Century Cutoff - Why Does Year 31 Become 1931?

Release Date: 12/06/2023
Version: 7.x & Up

Q - What is the latest date of the web services support?  We ran into a date with 2031 on an attribute date value and it was translated into 1931.

A - The date century cutoff issue is probably not web-services related. Web services uses the full 8-digit date with the 4-digit year. I think your issue is on the Elliott side since we only prompt for a 2-digit year with the user interface. Elliott 8.5 has the century cutoff at 30. That is to say, if you enter 12/31/30, it will be stored as 12/31/2030. If you enter 1/1/31, it will be 1/1/1931. 

On the other hand, Elliott 8.6 changes the century cutoff to 50. 

While you can run Elliott 8.5 and 8.6 side by side, if you want to enter dates in Elliott beyond 12/31/2030, then you can’t use Elliott 8.5 and 8.6 side by side. For example, if you enter the date 1/1/31 in 8.6, the date will be saved as 1/1/2031.  However, If you bring up that same date field in 8.5, it will be converted back to 1/1/1931. 

To avoid the year 30 cutoff issue, you should migrate to Elliott version 8.6 or after.


EMK

    • Related Articles

    • A Case to Diagnose Elliott SOAP Web Services Errors with Log Files

      'Release Date: 08/15/2024 Modified Date: 08/23/2024 Version: 8.5 & Up When a web developer calls Elliott SOAP web services, he/she should place a try catch block so if there is an error with the web services call, the error can be caught at the ...

    • Elliott API (JSON REST Web Service)

      Introduction In the past, Elliott web services is based on SOAP standard since that is the first web services standard created for the industry. Since then, RESTful APIs (Representational State Transfer) have become the backbone of modern web ...

    • Elliott Web Service Requirements

      Release Date: 5/22/2017 Q - What are the requirements for running Elliott Web Service? A - Elliott Web Service is built on .NET and runs on Windows. It extends a vast amount of Elliott features to external applications. Some of these features may ...

    • Converting Elliott Internal Date to Conventional Date Format in Excel

      Q - If I retrieve Elliott's data in Excel through ODBC, the date column is retrieved in an 8-digit numeric format like:20161231, where the first 4 digits are the years, the following 2 digits are the month, and the last two digits are the day of the ...

    • Convert Elliott Internal Date to Proper Date Format in Third-Party Tools (Crystal Reports)

      Release Date: 07/08/2024 Version: 8.5 & Up ELIDATE2SQL() User-Defined Function Elliott's internal database stores a date field as an 8-digit numeric in a YYYYMMdd format where YYYY is the 4-digit year, MM is the number of the month, and dd is for the ...