I have an issue with Importing a Timestamp as I need to modify the date format to fit the source file format. I cannot modify the format in the source file itself.
error parsing dateTime value =< 4/5/2023 08:24:13 > with dateTime format =< MM/dd/yyyy hh:mm:ss a >, caused by: java.time.format.DateTimeParseException: Text ‘4/5/2023 08:24:13’ could not be parsed at index 0"
I need to modify the dateTime format and add an option for “M/d/yyyy”