HPE NonStop SQL/MX Error – 20097 Date order dateorder is not valid.

Data 18 Views 1 Min Read

In this blog post, let’s learn about the error message “20097 Date order dateorder is not valid.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20097 Date order dateorder is not valid.

Reason for the Error

The date order that you specified was invalid.

Solution

Valid date order values are MDY, MYD, DMY, DYM, YMD, and YDM. Correct the date order in the DATE FORMAT section of the format file

Tags: