Date Conversion

[elvinh]

Hello All,

I am trying to convert a date column within my workflow from a string (formatted like 4/5) to a date format that includes the day, month and year (eg:04/05/2023, 04-05-2023). What would be the best way to do this?

Thank you!

[ShankerV]

Hi @elvinh 

When you say 4/5, which is month and date?

You can use formula tool to achieve the output.

[elvinh]

Hello, in this case it would be April/5 or M/d.

[ShankerV]

Hi @elvinh 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @elvinh 

It can be achieved in one simple formula like below, have explained in splits the previous thread to understand how it works. 

DateTimeFormat((datetimeparse(([Field1]+"/2023"),"%m/%d/%Y")),"%m-%d-%Y")

Many thanks

Shanker V

[elvinh]

Thank you!  This will work!