Maintaing same Date format in each row

Hi Everyone,

I am trying to change the date format from the Column “Deadline” to “dd-MMM-yy” Capture

Can someone please help me to understand how to solve this.

Many thanks in advance.

Regards
vishnu

1 Like

First use a Read Range activity to store the sheet in a datatable, then use a For Each Row activity with an assign activity inside it:

row("Deadline") = Convert.ToDateTime(row("Deadline")).ToString("dd-MMM-yy")

Then use a write range to write it back. Be sure to have ‘Add Headers’ checked.

2 Likes

Thank you for your quick reply Erik. Its worked perfectly.
Much appreciated your time and help.

Regards
Vishnu

2 Likes

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