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

Help Studio
1

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

2

Hi @Zara_Yasmin ,

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

1 Like
3

Hi @Zara_Yasmin

Welcome to the UiPath Community Forums! :partying_face:

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)

image
image261×186 7.03 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:

Hopefully this helps :blush:

Cheers

Steve

1 Like
4

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

5

Thanks a lot for the info

6

Hey @Zara_Yasmin

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

Cheers

Steve

7

Done… Thank you!!

1 Like
8

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