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


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:

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


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

It works, thank you!

variable DocData as double

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.