ChaningDateFormat for each row in Datatable?

Help
1

Hi everyone,

Is it possible to change the date format for each row in Data Table?

from 10-Nov-18 to 10/11/18 for each row of the column called “Date”

Someone please advice me how to achieve this.

Much Appreciated for your help in advance

Regards
Vishnu

2

Hi @winningvish

Try this i think it will help you

DateTime.Parse(yourString).ToString(“dd/MMM/yyyy”)

Best Regards
Farhan

1 Like
3

Hi Farhan,

Thank you for your quick reply. “posting” is the column stored in a Datatable variable.
How can I do this for Data Table?

date

Regards
Vishnu

4

Hi @winningvish

Please Find Below attached Workflow…

Main.xaml (7.8 KB)
New Microsoft Excel Workbook.xlsx (8.4 KB)

Regards
Farhan

5

Hi Farhan,

Somehow get understood the concept after gone through your workflow. But I am trying to achive the format like 12/11/18. I am using like dd/MM/yy

Which is throwing an error like “Assign: String was not recognized as a valid DateTime.”

6

Hi @winningvish

Try it know

Main.xaml (7.7 KB)
New Microsoft Excel Workbook.xlsx (8.4 KB)

Regards
Farhan

1 Like
7

Thank you So much Farhan.

It is working as expected.

Much appreciated your time and help.

Regards
Vishnu

1 Like
8

Most Welcome :blush::checkered_flag: