datetime with AM/PM returned wrong time
To test:
datetime("01/18/2022 12:30:00 PM", "InputFormat", "MM/dd/yyyy hh:mm:ss a")
datetime("01/18/2022 12:30:00 AM", "InputFormat", "MM/dd/yyyy hh:mm:ss a")
datetime("01/18/2022 12:30:00 PM", "InputFormat", "MM/dd/yyyy hh:mm:ss a", "OutputFormat", "MM/dd/yyyy hh:mm:ss a")
datetime("01/18/2022 12:30:00 AM", "InputFormat", "MM/dd/yyyy hh:mm:ss a", "OutputFormat", "MM/dd/yyyy hh:mm:ss a")
Edited by Adeline CARNIS