String to Date

[agathiyanv (Agathiyan)]

I need to convert ‘20210706’ - ‘06 jul 2021’
how to do this??

[kumar.varun2 (Varun Kumar)]

Hi @agathiyanv

Try this

Date.ParseExact("20210706", "yyyyMMdd", System.Globalization.CultureInfo.InvariantCulture).ToString("dd MMM yyyy")

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[Gokul001 (Gokul Balaji)]

HI @agathiyanv

Check out more info about the date format

DateTime Format In C#

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (https://forum.uipath.com/t/all-about-datatable-uipath/386445) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm…

Regards
Gokul