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
