Hi, I need to covert date to a particular format. Consider a string "06-23-3" which is in format MM-yyyy-dd . but the robo is reading the date as 23/06/2003 which is wrong

Help Studio
, ,
1

Hi, I need to covert date to a particular format. Consider a string “06-23-3” which is in format MM-yyyy-dd . but the robo is reading the date as 23/06/2003 which is wrong. Can anyone please help.

Forum Engagement Daily Reports
2

Hi @Aswin_Sutheesh17

Could you try the below expression,

- Assign -> InputDate = "06-23-3"
- Assign -> OutputDate = DateTime.Parseexact(InputDate.toString, "MM-yyyy-d", System.Globalization.Cultureinfo.InvariantCulture).toString("dd/MM/yyyy")

OutputDate is String Variable.

Hope it helps!!

3
4

Hi ,
its showing error
image

5

I have made a small mistake in expression, check the below one… @Aswin_Sutheesh17

- Assign -> InputDate = "06-23-3"
- Assign -> OutputDate = DateTime.Parseexact(InputDate.toString, "MM-yy-d", System.Globalization.Cultureinfo.InvariantCulture).toString("dd/MM/yyyy")

Hope you understand!!

1 Like
Forum Engagement Daily Reports
6

Hello @Aswin_Sutheesh17 ,

Try This ::

date1 (Of Type, String):: “06-23-3”

Output (Of Type, String) = DateTime.ParseExact(date1.ToString,(“MM-yy-d”),System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Hope This Works!!

Regards,
Jagruti Govindia

1 Like
7

It Worked Thankyou So Much :star_struck:

1 Like
8

It’s my pleasure… @Aswin_Sutheesh17

Happy Automation!!

1 Like
9

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