How to convert "2022-04-11 18:55:00 CT" String Date format to "Mar 11 2022, 18:55 CST"

[Zara_Yasmin]

How to convert “2022-04-11 18:55:00 CT” String Date format to “Mar 11 2022, 18:55 CST”

[Edwin_Barahona]

Hi @Zara_Yasmin ,

Date parsing is not complicated but is extense. These documents will help resolving this and future date formatting needs.

DateTime.Parse Method (System)

DateTimeFormatInfo Class (System.Globalization)

[Steven_McKeering]

Hi @Zara_Yasmin

Welcome to the UiPath Community Forums!

Did you mean April 11 in the second format?

I have created a workflow to assist you. Take a look here. Main.xaml (6.8 KB)

Note: Inputs in Red. Result in Orange.

I have referenced the Date Formats found here:
DateTime Format In C# (c-sharpcorner.com)

Steps undertaken:
Step 1: I had to remove the “CT” first.
Step 2: I then used CDate(Inputstring).tostring(Insert Date Format)
Step 3: Log output and validate result.

Take a look at this great post also:

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

Hopefully this helps

Cheers

Steve

[Zara_Yasmin]

Thank you very much useful… I was able to convert it. Thanks for all the efforts you put in der…

[Zara_Yasmin]

Thanks a lot for the info

[Steven_McKeering]

Hey @Zara_Yasmin

If I was able to solve your problem - please mark as solution so others are more likely to find it

Cheers

Steve

[Zara_Yasmin]

Done… Thank you!!