Hey,
I am performing some operations in a CSV file using Invoke code. When I open the file manually, i get the date column in the correct format. But when I open it with Invoke code/Excel application scope it changes the default format to MM/dd/yyyy format. For eg: the date 30/06/2018 is changed to ‘text’ and the date 01/07/2018 is still ‘date’ but January 7th. While opening manually the format is dd/MM/yyyy and so all the dates are in the expected format. Any idea why does this happen?