Updating dates in specific column?

Hi Uipath,

I need help about my automation problem.

let say I have the following Data below:

As you can see right now in the INPUT part it contains days of the month for july.

I want to update it to days of the current month just like in the OUTPUT part.

Hope someone can help me



Hi @aapostol,

Please follow below steps,

Read the input Excel.
Use for each row activity,
Use this expression to convert Date column Date.Parse(row(“Date”).toString).ToString(“dddd”).Substring(0,3)
You can write cell the output into Day

Hope, it helps. #HappyAutomation