How to convert string date to date

[dhanu_lokhande]

I want to convert date like 22 september 2020 to 22/09/2020
please suggest

[ppr (Peter Preuss)]

@dhanu_lokhande

22 september 2020

CDate(YourStringVar).toString("dd/MM/yyyy")

[dhanu_lokhande]

I got the error like CDate does not exist in the current context

[ppr (Peter Preuss)]

please share with us your modeling details

[dhanu_lokhande]

i have date in excel like 22 september 2023
which i have one website in that calender format in that i just have to type the date like 22/09/2023
how to do the conversion

[ppr (Peter Preuss)]

we had shown you the conversion and as it was done within the immediate panel it is proven, that it will work

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

@ppr

please share with us your modeling details

when asking the above we do not ask for repeating the case description. We ask for e.g. a screenshot of what you have modelled.

[arjunshenoy]

Hi @dhanu_lokhande

If you are open to suggestions, here is another approach:

DateTime.ParseExact(strValue2,"dd MMMM yyyy", Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Here, strValue2 = 22 september 2020

Output:

Hope this helps,
Best Regards.

[dhanu_lokhande]

Thank you it works