Hi guys,
Suppose I have a JSON string as below:
{"MessageID":"11111","save_date1":"2022-02-02 01:01:34","Sender_ID1":"esb","sent_date2":"1985-12-11 11:42:00"}
The two date variables are all formatted as ODBC date time, when I tried to import it to a %JSON.Adapter object, the date format was rejected as below
Error #9406:Unexpected format for value of field, save_date1, using class base mapping
Thus I'm trying to format all possible ODBC date time in the incoming JSON with Regular expression: