I am performing a ‘File Search’ from an excel. Getting details in ‘new.xlsx’ which contains Filename, Last Modified At etc…
When I do an excel loop on ‘new.xlsx’ file to find out the value of ‘Last Modified At’ column, it returns a number instead of date present in the column.(when column is set to Text data type)
and return 01/01/0001 00:00:00 when column is set to ‘DateTime’ within settings in excel loop activity.
Please find attached image for reference.
New.xlsx file also attached from which I am reading the value of ‘Last Modified At’ column
Kindly assist on how can I get the correct date present in the excel for ‘Last Modified At’ column.