I need some help extracting dates from excel file and change the date format:
for example :
The cell data in the excel is= “9/14/2021”
In studio (after using a “read range” activity into Data Table Variable) I am trying to write the data (with “assign” and “write Line”) into another excel file, but the result is = “9/14/2021 12:00:00 AM”
I just need the date without the hours and the format to be “dd/MM/yyyy” (change the months with the days)
How can I do it?
thanks in advance