Date Conversion - .net syntax

prabhu_ponnusamy · July 28, 2020, 9:07am

How do I convert April 28,2015 to 04/28/15

Mr_JDavey · July 28, 2020, 9:23am

Hi there @prabhu_ponnusamy,
The following should work:
DateTime.ParseExact("April 28,2015", "MMMM dd,yyyy", Nothing).ToString("MM/dd/yy")

This converts the value “April 28,2015” into a DateTime value, then converts it back into a String, using the format “MM/dd/yyyy”.

Pratik_Wavhal · July 28, 2020, 9:33am

Just by doing below thing also you can get the output that you are expecting :-

Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal

system · November 7, 2023, 11:59am

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

Topic		Replies	Views
Date Conversion Question Studio studio , string , question , data_manipulation	3	814	March 15, 2020
Convert to DateTime Studio studio , question , activities_panel	3	21	December 2, 2024
How to Convert String(yyyy/mm/dd) To Date Studio studio , question , activities_panel	4	2102	September 13, 2022
How to convert String value to DateTime? Help studio , string , question	10	1576	January 22, 2020
How to convert a string in MM/dd/yyyy into dd/MM/yyyy in DateTime Format Learning Hub question	6	6394	July 22, 2020