i have a csv which i am importing to a datatable Status,Reference,Started Successful,Task1,9/20/2021 11:49:34 AM, Successful,Task1,9/10/2021 11:51:12 AM, Successful,Task2,9/15/2021 11:52:51 AM, Successful,Task3,9/12/2021 11:53:53 AM, Fail,Task 1,9/01/2021 11:55:07 AM, Successful,Task 2,9/20/2…

[image] adrian_sullivan: DTData.AsEnumerable.Where(Function(x)x CDate(x(“NewDate”).ToString).Date >= (new DateTime(2022,9,01)).Date andAlso CDate(x(“NewDate”).ToString).Date <= (new DateTime(2022,9,20)).Date).CopyToDatatable @adrian_sullivan , There is a floating x in the query, it should be…

That’s because you are using ParseExact Try using DateTime.Parse(string_var), that should work for you Thanks, Nishant

Your date format is wrong. Try this: DateTime.ParseExact(row.item(“Started”).ToString,“MM/dd/yyyy hh:mm:ss tt”,Globalization.CultureInfo.InvariantCulture) The format has to match your date input string’s format which is 9/14/2021 12:18:43 PM

ParseExact works fine. He just provided an incorrect format.

That’s right! Nothing wrong with ParseExact. I suggested Parse since this would be a quick-fix and would encompass any changes (if any) in future Regards, Nishant

[image] postwick: DateTime.ParseExact(row.item(“Started”).ToString,“MM/dd/yyyy hh:mm:ss tt”,Globalization.CultureInfo.InvariantCulture) still getting an error [image]

[image] supermanPunch: CDate(row("Started").ToString) CDate(row(“Started”).ToString) outputs the date as 06/24/2022 12:36:40 - which is ok but… when i try an run a filter on it for records after a specified time eg 06/23/2022 there is nothing returned. i have tried a few different date opti…

[image] adrian_sullivan: [image] @adrian_sullivan . Unless the NewDate column is a DateTime type of data column we will get inaccurate results with Filter Datatable activity. For such filter cases, we use Linq approach for a less step execution work around. In your case, the Linq query wou…

thanks for taking the time to help with this that is working for me now - one last question \ tweek i dont need the filter for Successful, i tried to remove it but the query keeps breaking. also if i wanted to set a max date as well would it look something like this andAlso CDate(x(“NewDate”).ToS…

[image] adrian_sullivan: i tried to remove it but the query keeps breaking. [image] adrian_sullivan: like this andAlso CDate(x(“NewDate”).ToString).Date <= (new DateTime(2022,9,25)).Date) @adrian_sullivan , Could you provide more details on what exactly do you mean by it keeps breakin…

Datatable convert object to date time field

Help Studio

supermanPunch (Arpan) September 25, 2022, 7:24pm 11

@adrian_sullivan ,

Have you tried to use the CDate() method and checked if it is working ?

CDate(row("Started").ToString)

If it does not work, You could check my above post or directly linking the Section of the post on allowing different date time format specifications is provided below :

Topic		Replies	Views
Convert datatable strings column to datetime Studio datatable , studio , string	11	15688	January 11, 2023
Convert 01012020 date format to 01-01-2020 Activities datatable , excel , activities , error	9	2897	November 25, 2020
How to Update Date format in whole column of Datatable Reboot Your Skills 2021 activities , studiox_training	13	10492	September 23, 2020
Filtering the datatable between Dates Studio studio , question , activities_panel	14	516	April 6, 2024
Datetime format in datatable Studio	22	2124	November 8, 2022

Datatable convert object to date time field

Related topics