String conversion to datetime

Hi all

I want to convert my string to datetime format.

But the string is in format of MMddyy

Example

String- 070120

Can anyone help me with this

Hi @emm

Please check

Mark as solution if this helps

Thank you

@emm Since you know the format of the date, this would be another method to get the String Date to a DateTime format

DateTime.ParseExact(“070120”,“MMddyy”,System.Globalization.CultureInfo.InvariantCulture)

Hi @emm

Below is the workflow which gives your output
looksLikeDate.xaml (5.3 KB)

Output as below :-
image

Hope this workflow may help you to solve your query
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Try this: DateTime.ParseExact(yourstringVariable,“MMddyy”,System.Globalization.CultureInfo.InvariantCulture)

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