String to Date issue

Help Studio
, ,
1

How can I transfer “Feb 14, 2021” to “2021/2/14”?

2

Hi,

Can you try the following expression?

DateTime.ParseExact(yourString,"MMM d, yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy/M/d")

Regards,

1 Like
3

You can use this below code, @Chen_Kenny
Cdate(“Feb 14, 2021”.Replace(“,”,“”)).ToString(“yyyy/M/dd”)
Hope this may help you :slight_smile:

1 Like
4

I think @Yoichi

It should be like this

DateTime.ParseExact(yourString,“MMM dd, yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy/M/dd”)

Instead of d it would be dd

Correct me if I’m wrong

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

1 Like
5

Hi @NIVED_NAMBIAR ,

Both will work for the above input string.
The difference is : If we set d in ParseExact, (for example)"Feb 7, 2021" and "Feb 07, 2021" both will be valid. However if we set dd, only Feb 07, 2021 will be valid.
And output style will be also different like 2021/2/7 and 2021/2/07.

Which is better depends on the requirements.

Regards,

2 Likes
6

Hi @Yoichi

Thanks for response :blush:

1 Like
7

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