Hi All, I have to Convert a excel cell value to particular date format. Input: Fri Jan 20 00:00:00 2022 I need an output in this format(dd/MM/yyyy hh:mm:ss) 20/01/2022. Please help me with this question. Regards, Manoj

HI @manojmanu.rpa Try with this expression DateTime.ParseExact(System.Text.RegularExpressions.Regex.Replace("Fri Jan 20 00:00:00 2022","^\S{3}\s",""),"MMM dd hh:mm:ss yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy hh:mm:ss") [image] Regards Gokul

Need to Change Date Format from string to Date

Help Activities

balupad14 (Balamurugan) January 24, 2023, 2:40pm 11

Hi @manojmanu.rpa ,

Take a look on this.

Regards
Balamurugan.S

Topic		Replies	Views
Convert date to specific format Studio	13	5741	September 29, 2023
Convert format date from string Activities excel , activities , question	1	706	May 18, 2021
How to change the excel date format from DD/MM/YYYY to YYYY-MM-DD Studio studio , question , activities_panel	4	1513	April 7, 2023
Convert a string to Date format Activities excel , activities , question	10	9117	January 8, 2022
Excel string to date Activities datatable , excel	4	276	February 3, 2024

Need to Change Date Format from string to Date

Related topics