Hi, Currently im working on a process where i need to filter two datetime columns. [Capture] This is the data table here i want to filter data [Sales Date] = DateTime.now.ToString() and [Action taken on] >= DateTime.now.Adddays(-1) and [Action taken on] <= DateTime.now.ToString() And the below…

Please use the below query, modify the condition if necessary (from i in sampleDt where DateTime.FromOADate(cdbl(i("Sales Date"))).Date = now.date or DateTime.FromOADate(cdbl(i("Sales Date"))).Date <= now.date AndAlso DateTime.FromOADate(cdbl(i("Sales Date"))).Date >= now.AddDays(-1).Date select i)…

[image] DataTable filter conditions Studio What @Yoichi said is right. I just re-did what she have done. Follow steps Assign this in new DT dt = (From dr As datarow In dt Where DateTime.FromOADate(Double.Parse(dr.item("Start Date").ToString)).Date=Today AndAlso DateTim…

Thanksfor the suggestion. But couldyou explain me the last line New Date(Now.Year,Now.Month,1).AddMonths(-1) Why do we use Now.Year,Now.Month,1

This for subtracting one month from current month

This will always give you date equal to first day of previous month. You can place there your own date. What is you business rule? Because in the second row you showed day in January, so its definitely not yesterday :wink: If both conditions need to be fulfilled then u should use the operator “and…

You can use the below query in the Assign activity to filter according to your condition (from i in sampleDt where DateTime.FromOADate(cdbl(i(“Sales Date”))).Date = now.date select i).toarray [image] Modify the condition and column names to apply the same for other logics DateFilter.zip (29.2 K…

Hi Yes. Its an or condition since i want any one of them to be true. But if i want to filter yesterday to today, do i need to apply AddDays(-1)? (From dr As datarow In DtP Where DateTime.FromOADate(Double.Parse(dr.item(“Initiated On”).ToString)).Date=Today Or DateTime.FromOADate(Double.Parse(dr.Ite…

Remember that dates has time too, so if u compare date = today than you will get only results like: 20/03/2021 00:00:00 Thats why there is >= operator :slight_smile: If in that column can appear future date (like tomorrow) than u need to add two conditions date>=Today and date < Today.AddDays(1) …

[image] Muthulakshmi_Thangamuthu: (From dr As datarow In DtP Where DateTime.FromOADate(Double.Parse(dr.item(“Initiated On”).ToString)).Date=Today Or DateTime.FromOADate(Double.Parse(dr.Item(“Action taken on”).ToString)).Date<=Today AndAlso DateTime.FromOADate(Double.Parse(dr.Item(“Action taken o…

Thanks @noufalahammed i tried it but still its showing error (From dr As datarow In DtP Where DateTime.FromOADate(Double.Parse(dr.item(“Initiated On”).ToString)).Date=Today Or DateTime.FromOADate(Double.Parse(dr.Item(“Action taken on”).ToString)).Date<=Today AndAlso DateTime.FromOADate(Double.Pars…

Thanks much @noufalahammed It works…

Issue in filtering date time column

Help Studio

Lakshay_Verma (Lakshay Verma) March 20, 2021, 11:42am 2

Check this out… Similar use case

Topic		Replies	Views
Filter a day before and the current date - Excel Help	7	1833	February 13, 2020
DataTable filter conditions Studio	11	2245	March 19, 2021
日付でフィルタリング（今日から〇日前の間）フォーラム datatable , excel , activities , studio	6	2498	September 25, 2021
Filter datatable column between a date range Studio datatable , studio , question , activities_panel , datetime , datatable-filter	5	320	May 27, 2024
Data table filter based on date range values Studio studio , question , activities_panel	9	1926	September 24, 2022

Issue in filtering date time column

Related topics