How to convert date from general format to DateTime format

[Tanvi_Sharma]

We are trying to read excel having one of the column as the date. After reading the excel we have taken the result in a datatable. Now we are trying to get the each date from the datatable.
When the excel was read it converted all the date value to the general format.

Now how to convert the date from the general format to the DateTime format as we want to compare the each value to the present date.
Here is the file for the reference.
DOB.xlsx (9.4 KB)

[Sheshrocks (Shesh)]

Hi @Tanvi_sharma, try below, should work

Conversion:
dateTime dt = DateTime.ParseExact([your column].toString, “MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture)
string strOut = dt.ToString(“MM/dd/yyyy”)

Comparison:
use Cdate(strOut) function

Hope it helps!

[rahamtullah (Mohammed Rahamtullah)]

Hi Tanvi,

Below thread might help you with your requirement.

How to select data table with date format when I read range to Excel?

Hi all, Does anybody know how to simple way how to extract data table items from the table that was read from Excel file? In my case, there is 3 column in a Excel, ID, Name and DateTime, for example. And when I read it with Read-range activity, all data will be read as String format and I cannot use Datatable.select activity with date time fo-rmat. (Like Datetime < now() - 1 day.) Indeed, it is able to separate data if I use for each row and convert string to Datetime format but I think it mi…

Regards,
Rahamtullah

[ranjith]

@Tanvi_Sharma

In your case date value is not complete. So use the below expression in assign activity to convert into data value

datatime_variable = DateTime.ParseExact("18-Jun", “dd-MMM”,System.Globalization.CultureInfo.InvariantCulture).tostring