# Filter datatable column between a date range

**URL:** <https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511>\
**Category:** Studio\
**Tags:** datatable-filter, activities-panel, datatable, datetime, question, studio, system, activities\
**Created:** [May 27, 2024, 6:58am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511 "2024-05-27T06:58:25Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yugal\_Raju](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yugal_raju/32/268628_2.png) [@Yugal\_Raju](https://forum.uipath.com/u/Yugal_Raju)\
**Post date:** [May 27, 2024, 6:58am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/1 "2024-05-27T06:58:25Z")

</div>

Hello All,

i need to filter a column in data table between two dates. Today’s date and +7 days from today date,

I have a column “StartDate” which in Date format in the excel.

 ![image](https://global.discourse-cdn.com/uipath/original/4X/1/f/1/1f1f82ea75bffb7bae8e644940aa23e1908a21dc.png)

I have assigned to two variables  
str\_firstday = DateTime.Now.ToString(“MM.dd.yyyy”)  
str\_Seventhday = Now.AddDays(+7).ToString(“MM.dd.yyyy”)

Can you please tell me a to filter “StartDate” column dates between str\_firstday and str\_Seventhday

Thank you

---

<div class="post-metadata">

**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\
**Post date:** [May 27, 2024, 7:05am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/2 "2024-05-27T07:05:15Z")

</div>

@Yugal_Raju

Read the data and then in assign use below

`requireddt = dt.AsEnumerable.Where(function(x) Cdate(x) > Now AndAlso CDate(x) < Now.AddDays(7)).CopyToDataTable`

cheers

---

<div class="post-metadata">

**Author:** ![rlgandu](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/rlgandu/32/488436_2.png) [@rlgandu](https://forum.uipath.com/u/rlgandu)\
**Post date:** [May 27, 2024, 7:05am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/3 "2024-05-27T07:05:36Z")

</div>

@Yugal_Raju

```auto
str_firstday=DateTime.Now.ToString("MM.dd.yyyy")
str_Seventhday=DateTime.Now.AddDays(7).ToString("MM.dd.yyyy")

Use Filter datatable activity

<Column Name="StartDate" Operation=">=" Value="str_firstday" />
        <Column Name="StartDate" Operation="<=" Value="str_Seventhday" />

```

---

<div class="post-metadata">

**Author:** ![lrtetala](https://avatars.discourse-cdn.com/v4/letter/l/e19b73/32.png) [@lrtetala](https://forum.uipath.com/u/lrtetala)\
**Post date:** [May 27, 2024, 7:06am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/4 "2024-05-27T07:06:50Z")

</div>

Hi @Yugal_Raju

```auto
str_firstday = DateTime.Now.ToString(“M/dd/yyyy”)
str_Seventhday = Now.AddDays(+7).ToString(“M/dd/yyyy”)

```

```auto
DT.AsEnumerable().Where(Function(row) DateTime.Parse(row.Field(Of String)("Date")) >= str_firstday AndAlso DateTime.Parse(row.Field(Of String)("Date")) <= str_Seventhday).CopyToDataTable()

```

Regards,

---

<div class="post-metadata">

**Author:** ![Maheswar\_Reddy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/maheswar_reddy/32/463722_2.png) [@Maheswar\_Reddy](https://forum.uipath.com/u/Maheswar_Reddy)\
**Post date:** [May 27, 2024, 7:09am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/5 "2024-05-27T07:09:41Z")

</div>

Assign today = DateTime.Now  
Assign lastdate = today.AddDays(7)

```auto
Assign filteredDataTable = (From row In dataTable.AsEnumerable()
                            Where DateTime.Parse(row("StartDate").ToString()) >= today AndAlso DateTime.Parse(row("StartDate").ToString()) <= lastdate
                            Select row).CopyToDataTable()

```

🙂

---

<div class="post-metadata">

**Author:** ![Yugal\_Raju](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yugal_raju/32/268628_2.png) [@Yugal\_Raju](https://forum.uipath.com/u/Yugal_Raju)\
**Post date:** [May 27, 2024, 8:55am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/6 "2024-05-27T08:55:43Z")

</div>

This worked for me , Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [May 30, 2024, 8:56am UTC](https://forum.uipath.com/t/filter-datatable-column-between-a-date-range/743511/7 "2024-05-30T08:56:27Z")

</div>

Closed on May 30, 2024, 8:56am UTC

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