Dears, Am trying to extract a date format correctly base on excel format, says in excel list all start from dd/MM/yyyy, but extracted out data to email somehow would show MM/dd/yyyy 00:00:00 from excel [image] to output email [image] how to let the robot to read the format correctly and remove…

Hi @Alfred_Gan Try with this one "Dear Sir/Madam,<p>This is an alert to request a quotation on the following items: <p>Description" +row("Description").ToString+"<p>Expiry Date: "+DateTime.ParseExact(row("Expiry Date").ToString,"d/M/yyyy hh:mm:ss",System.Globalization.CultureInfo.InvariantCulture)…

How to extract the date format from excel correctly?

Help Studio

ppr (Peter Preuss) August 8, 2022, 7:55am 14

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
Date format extracted from a excel cell - preserve format Activities excel , activities , question	5	717	January 27, 2023
How to Extract Date from excel file Studio studio , question , workflow_diff	21	904	November 8, 2022
Extract date from excel and change format Studio studio , question , activities_panel	4	1125	July 18, 2021
Extract Date from excel file Studio studio , question , activities_panel	8	1696	July 16, 2021
Extract dateTime Format as string Help	6	2965	July 12, 2019

Most Active Users - Yesterday
ashokkarale
mkankatala
Parvathy
vrdabberu
sandyarpa767
pravallikapaluri
gantamohan502
indiedev91
naveen.s
Anil_G
More details...

How to extract the date format from excel correctly?

Related Topics