Extracting dates from excel file and change the date format

Help Studio
, ,
1

hello,
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

2

give a try on CDate(YourRowVar(YourColNameOrIndex).toString).toString(“dd/MM/yyyy”)
grafik

3

its works!

thanks a lot

4

Perfect. Once you have done with the final testing just close the topic by marking the solving post as solution. Thanks

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.