For some reason, when i use Read Range on an Excel workbook, then in the For each row, i extract column index 1 which is a date, it changes the month and day around (dd/mm/yy extracts as mm/dd/yy). EG: 16/08/19 extracts as 08/16/19 and crashes on the Parse Date as there is no 16th month.
It has not happened before when doing Read range, so not sure why it started now on this workflow. Could i have forgotten to install a certain package on this workflow? or am i missing something? Which packages do you all use for date.time stuff?