I am trying to read a Excel file with Some Dates in different formats.
I tried this in different environments with combinations of
I got a successive output from first two environments, but fails in IIS/Windows Environment.
For example, If my Input is 12/1/1972 (MM/DD/YYYY), first two environments returns 01/12/1972 (I need to perform some replace here to get 12/01/1972), but in IIS/Windows environment I got totally different output as 30/11/1972.
Kindly let me know the way to handle this.