I am configured my Region and Time as below:
So, with that I will be having dates in the excel format as dd/MM/yyyy
Now, I am reading that excels using Read range, returning the date values in the date table as MM/dd/yyyy hh:mm:ss and some times dd/MM/yyyy hh:mm:ss.
So, why this inconsistency with Read range either it should give any one of the above formats only. But not in this case…
Any ideas on this?