Date time (String) from Data Table to OA Date (serial number)

[c0Ld (Luís Silva)]

Hi,

I have a data table created from an read range of an Excel File. There I have a column with dates that I need. This column is in Date format: 05/08/2020

When I get the date: row(“date”).toString the date becomes:
[08/05/2020 00:00:00]

Now, what I want is the serial number of this date, or the OA Date (I think).

In this link, the issue is opposite:

Date conversion from excel value saved as number

Hello, I am trying to convert the following Date from excel to DateTime but I get this error: Conversion from string “44053” to type ‘Date’ is not valid. [Date] UIPath Studio sees the date as string: [UIPAthDate] And this is what i have tried: [Condition]

I need to get the serial number. Thanks for any help!

[ppr (Peter)]

we will use the ToOADate method from a variable Of datatype: DateTime

[c0Ld (Luís Silva)]

It works, thank you!

variable DocData as double

DocData = CDate(row(“date”).ToString).ToOADate