Get date value as a string

Help Studio
, ,
1

Hello All,

I have an excel file that contains two different formats of date values i.e (“9/29/1980”, “10-11-1980”). It gives me out as respective for row is i.e (“9/29/1980”, “11/10/1980 00:00:00” ).
I want this row value as it that present in the excel row.

Thank!

2

@Pradumn_Chavan
welcome to the forum

not recommended and slowing down: check a run when preserve Format is activated on read range

3

Can you please mention step how to get data in preserve format.

4

grafik

5

If I tick preserve format debug process is continuously running it’s not showing me any output.

6

Row.fieldof(datetime)(“excelColumnNameWhereTimestampExists”).tostring

7

thats why gave the statemtent. In order to select an suggestion what is the motivations to keep it?

8

Needed to type as it is data that are present in excel file.

9

@pauloengenharia5 that means you are getting each row and typing it somewhere? Also, do you reading the data from excel to datatable

10

maybe better to get the data in excel with leading ’ like '10-11-1980
then excel is forced to keep it as text, preserve format can be unselected, the read range is not slowing down and the format / value is kept

11

Not working any of the solutions. Anyone has any idea for same.

12

for a RnD round manually adding the ’ in the Excel was not working?

13

Sorry, but I can’t understand what you are saying.

14

Perfect, but is a difference to

RnD Round - remove unneded rows and test it on a small set with data reflecting the different cases

  • open Excel
  • on the relevant cell add a ’ (single quote) befor the value
  • Save an close Excel
  • readin with with read range without the preserve format option and check the result within the datatable

A leading ’ will force Excel to treat the value as text and this will influence read range result

15

@Pradumn_Chavan Could you please explain the scenario a bit more. You are getting that date format from excel and are you trying to enter it somewhere

16

@Pradumn_Chavan You can loop through each row in data table and format that changed date value. did you try that ?

17

Yes, I tried that. But when I use to format it will take only one separate date field either " - " or " / ". But I want this date as a string like it that is present in the excel row.

18

Welcome to the UiPath Community forums @Pradumn_Chavan :partying_face:

Can I ask some more questions to clarify your requirements.

Input row value samples:
“9/29/1980”, “10-11-1980”

Currently writing values in excel as:
“9/29/1980” OR “11/10/1980 00:00:00”

What does your Expected Output look like?
“9/29/1980” OR “11/10/1980" OR something else?

Cheers

Steve

19

I want output like if the date in excel = “9-02-2022” then I want as it is “9-02-2022” same.
If date = “9/02/2022” then I want “9/02/2022”. When I take a date in uipath it’s changing this date separator.

20

HI @Pradumn_Chavan,
as already written the “PreserveFormat” property should do the job:

image
image1084×575 18 KB

Output in debugger:
image

So not entered as DateTime in this case…