# Date format for query filter

**URL:** <https://forum.inductiveautomation.com/t/date-format-for-query-filter/96105>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 18, 2024, 9:07am UTC](https://forum.inductiveautomation.com/t/date-format-for-query-filter/96105 "2024-09-18T09:07:21Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 18, 2024, 10:08am UTC](https://forum.inductiveautomation.com/t/date-format-for-query-filter/96105/4 "2024-09-18T10:08:53Z")

</div>

> [@Alejandro\_Alaco](#):
>
> is expecting a date with format MM/YYYY

Why? Why are you not using proper timestamps in your query?

> [@Alejandro\_Alaco](#):
>
> `TO_CHAR(WO.WORKREQUESTDATE, 'MM/YYYY') = :startDate`

This means that every row in your data table must be converted to see if it matches the startDate. You can't take advantage of the database index on the WORKREQUESTDATE column (if you have created one - which you should if that is the way you will query). Your query will be slow.

---

_[View the full topic](https://forum.inductiveautomation.com/t/date-format-for-query-filter/96105)._