How to change 3 different date Format String value to DateTime

Is there any good way to change all of the following string dates to DateTime type?

20210101 ←YYYYMMDD
21/01/01 ←YY/MM/DD
01/01/2021 00:00:00 ←DD/MM/YYYY 00:00:00

The above three values are all imported in the same String variable.
So I’m looking for a way to get these three different formats to come in and still be properly stored in a DateTime type variable as January 1, 2021.

【What I did】
At first I used “Convert.ToDateTime(DateStringVariable)” to convert, but with the advent of 21/01/01, I ran into a problem where I could not convert.

And next, I was converting “21/01/01” to “2021/01/01” by putting 20 in front of it, but next came “01/01/2021 00:00:00” and I am encountering the problem of not being able to convert with “2001/01/2021 00:00:00”.

Therefore, I thought of a process to convert “21/01/01” to “2021/01/01” based on whether the target string contains “2021” or not as one method, but it turned out that I could not judge by 2021 because I needed to process 2021 in 2022.

To be honest, I have not found a good way to do this.
If you know anything about this, please let me know.

Thank you very much.


Check below for your reference


Hope this may help you



Hope the following helps you

Sequence1.xaml (10.1 KB)



Hi @Kirigirisu_Coin

Please give a try,

strText - your string variable

Use an switch activity and in expression give,

If(strText.Contains("/"),"format1",If(strText.Contains(":"),"format2", "Default"))

Add case in switch activity

Case : format1

Add an assign activity and give,

Date.ParseExact(“yy/MM/dd”,strText,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM dd,yyyy”)

Case : format2

Add an assign activity and give,

Date.ParseExact(“dd/MM/yyyy hh:mm:ss”,strText,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM dd,yyyy”)

Case : Default

Add an assign activity and give,

Date.ParseExact(“yyyyMMdd”,strText,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM dd,yyyy”)


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