How do I change String to DateTime for multiple columns at once?

Hello,

I have 3 columns Settled_Date, Invoice_Date, Due_Date with different values like the image attached below. I need to convert to DateTime data type. How do I do this? I tried DateTime parse and Multiple Join, it worked but it would give me 3 icons and would not join those icons. Thank you for your help!

Date Time

Accepted answers

Hey @nhubaorai,

Does this approach work for you?

All comments

Use the Multi-Field Formula tool.

What do you mean by "it would give me 3 icons and would not join those icons"? Can you post a sample workflow?

Chris

Hey @nhubaorai, could you give a sample dataset?

Thank you for your reply. Here is my sample workflow. Three DateTime Convert icons. When I do Join Multiple, it gives me an error.

Thank you for your reply. Here is my sample dataset.

Hey @nhubaorai,

Does this approach work for you?

Works perfectly. Thank you so much!

Great ! no worries @nhubaorai 😄

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

Hollingsworth 335