# Perspective table column filter with date render

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-date-render/75983>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 6, 2023, 9:52am UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-date-render/75983 "2023-07-06T09:52:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Max\_Tymoshenko](https://avatars.discourse-cdn.com/v4/letter/m/df705f/32.png) [@Max\_Tymoshenko](https://forum.inductiveautomation.com/u/Max_Tymoshenko)\
**Post date:** [July 6, 2023, 9:52am UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-date-render/75983/1 "2023-07-06T09:52:28Z")

</div>

Good day to everyone!  
I tried to use feature of separate column filtering in Perspective table component and ran into a little problem. While "string" render columns work good, "date" render columns don't work. I think, that's because I use non-standart date format.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/3/4343ac3773a65e25bab62386a3cc89aac317e23f.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a1b1863d4a10da0f47bfa3b5f66f489cb1061d8.png)

No matter what filter condition I use, result count always is 0.  
Tried to use standart datetime format

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/2/92439c507b14ed2210e28947cb369abf46e398d1.png)

But it didn't work either.  
Any suggestions what can I do in this situation? Maybe is it possible somehow to change datetime format in filter mechanism? Thanks in advance!

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/5/f57ee05eb2ef37a9b1f6f40b388b2a75c847cce3.png)

---

<div class="post-metadata">

**Author:** ![Max\_Tymoshenko](https://avatars.discourse-cdn.com/v4/letter/m/df705f/32.png) [@Max\_Tymoshenko](https://forum.inductiveautomation.com/u/Max_Tymoshenko)\
**Post date:** [July 8, 2023, 7:47am UTC](https://forum.inductiveautomation.com/t/perspective-table-column-filter-with-date-render/75983/2 "2023-07-08T07:47:51Z")

</div>

I took dataset from tag with already defined column types, built new dataset with some changes via script without datatypes definition and then added it to table.props.data. As a result, all types in new dataset was string. Rendering columns changed visual representing in table, that's why I didn't notice this. Building DS with strict column types solved my problem, all works fine.