# Filtering the date column - from data table

**URL:** <https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709>\
**Category:** Studio\
**Tags:** activities-panel, question, studio, excel, system, activities\
**Created:** [March 14, 2023, 1:02am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709 "2023-03-14T01:02:15Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sisay\_Dinku](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sisay_dinku/32/263491_2.png) [@Sisay\_Dinku](https://forum.uipath.com/u/Sisay_Dinku)\
**Post date:** [March 14, 2023, 1:02am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/1 "2023-03-14T01:02:15Z")

</div>

Hi there,

I was trying to filter a couple columns from the data table. However, the date column is throwing an error " String was not recognized as a valid dat time "

Could you please help. Thanks

---

<div class="post-metadata">

**Author:** ![Yoichi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yoichi/32/523754_2.png) [@Yoichi](https://forum.uipath.com/u/Yoichi)\
**Post date:** [March 14, 2023, 1:05am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/2 "2023-03-14T01:05:23Z")

</div>

Hi,

Can you share current settings or expression?

Regards,

---

<div class="post-metadata">

**Author:** ![Sisay\_Dinku](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sisay_dinku/32/263491_2.png) [@Sisay\_Dinku](https://forum.uipath.com/u/Sisay_Dinku)\
**Post date:** [March 14, 2023, 1:12am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/3 "2023-03-14T01:12:46Z")

</div>

Hi @Yoichi  
Here is the current expression

dt\_DataSource.AsEnumerable.where(Function(x) x(“Customer Name”).ToString.Equals(“PACIFIC SUNWEAR OF CALIFORNIA”) And x(“Warehouse Id”).ToString.Equals(“09”) And DateTime.parseExact(x(“Start Dt”).ToString,“MM/dd/yyyy 00:00:00”,system.Globalization.CultureInfo.InvariantCulture).To  
[SourceData\_2.xlsx](https://forum.uipath.com/uploads/short-url/49myNIV44mXQn8p6qS9ynpAPbm2.xlsx) (13.5 KB)  
String(“dd/MM/yyyy”).Equals(“01/04/2023”)).CopyToDataTable

Also I want the leading zero removed from the “cust purchase order” column.

---

<div class="post-metadata">

**Author:** ![Yoichi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yoichi/32/523754_2.png) [@Yoichi](https://forum.uipath.com/u/Yoichi)\
**Post date:** [March 14, 2023, 1:19am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/4 "2023-03-14T01:19:53Z")

</div>

Hi,

For now, can you try to use DateTime.Parse instead of ParseExact, as the following?

```
dt_DataSource.AsEnumerable.where(Function(x) x("Customer Name").ToString.Equals("PACIFIC SUNWEAR OF CALIFORNIA") And x("Warehouse Id").ToString.Equals("09") And DateTime.Parse(x("Start Dt").ToString).ToString("dd/MM/yyyy").Equals("01/04/2023")).CopyToDataTable

```

Regards,

---

<div class="post-metadata">

**Author:** ![Sisay\_Dinku](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sisay_dinku/32/263491_2.png) [@Sisay\_Dinku](https://forum.uipath.com/u/Sisay_Dinku)\
**Post date:** [March 14, 2023, 1:24am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/5 "2023-03-14T01:24:32Z")

</div>

Hi @Yoichi

I still get the same error. Could there be other options?

Thanks!

---

<div class="post-metadata">

**Author:** ![Yoichi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/yoichi/32/523754_2.png) [@Yoichi](https://forum.uipath.com/u/Yoichi)\
**Post date:** [March 14, 2023, 1:33am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/6 "2023-03-14T01:33:57Z")

</div>

Hi,

Probably because ReadRange reads extra blank rows. Can you try the following expression? This uses AndAlso instead of And.

```
dt_DataSource.AsEnumerable.where(Function(x) x("Customer Name").ToString.Equals("PACIFIC SUNWEAR OF CALIFORNIA") AndAlso x("Warehouse Id").ToString.Equals("09") AndAlso DateTime.Parse(x("Start Dt").ToString).ToString("dd/MM/yyyy").Equals("01/04/2023")).CopyToDataTable

```

Regards,

---

<div class="post-metadata">

**Author:** ![Sisay\_Dinku](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sisay_dinku/32/263491_2.png) [@Sisay\_Dinku](https://forum.uipath.com/u/Sisay_Dinku)\
**Post date:** [March 14, 2023, 1:42am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/7 "2023-03-14T01:42:10Z")

</div>

@Yoichi you’re the best.

Thanks a lot. It worked. I tested with the input files I have.  
Maybe I will create another topic for the leading zero removal one (Cust Puchase Order Column). Is there any way we can do it at the same time? Thanks a lot!

---

<div class="post-metadata">

**Author:** ![Sisay\_Dinku](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sisay_dinku/32/263491_2.png) [@Sisay\_Dinku](https://forum.uipath.com/u/Sisay_Dinku)\
**Post date:** [March 14, 2023, 1:53am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/8 "2023-03-14T01:53:12Z")

</div>

FYI - the prior expression also worked when ‘Andalso’ added. Thanks for the insightful conversation.

---

<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:** [March 17, 2023, 1:53am UTC](https://forum.uipath.com/t/filtering-the-date-column-from-data-table/525709/9 "2023-03-17T01:53:44Z")

</div>

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