I am reading a list of Dates in excel. Excel region settings are Australian (so dd/mm/yyyy). Excel file sample is:
Using the excel parser the output is all converted to American format (mm/dd/yyyy):
SnapLogic clearly knows it is dealing with Dates.
Of course, I can convert to other formats, but are there Snaplogic settings that will keep the original format?
I guess the good news is that the integrity of the date is still correct, but why would SnapLogic change the format? If anything, I would prefer a reformat to UTC…