# Report filtering by date

**URL:** <https://forum.inductiveautomation.com/t/report-filtering-by-date/88007>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [March 27, 2024, 8:25pm UTC](https://forum.inductiveautomation.com/t/report-filtering-by-date/88007 "2024-03-27T20:25:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [March 27, 2024, 8:25pm UTC](https://forum.inductiveautomation.com/t/report-filtering-by-date/88007/1 "2024-03-27T20:25:11Z")

</div>

I'm using Vision (7.9.10) - For some reason I always forget how to do this.

I've created a new report and in my parameters I made 2 new parameters Begin which is a string and Stop which is a string. I use these 2 parameter to insert a variable DATE from a datetime box into my SQL Query to filter out my data needed by date.  
The part I always forget is in my report viewer where do I bind my STARTDATE and ENDDATE variables to?

There use to be a video on Ignition that showed how to create a report using these 2 parameters Begin and Stop to insert into a SQL Query, but I could not find it.

---

<div class="post-metadata">

**Author:** ![Eric\_Alvey](https://avatars.discourse-cdn.com/v4/letter/e/8797f3/32.png) [@Eric\_Alvey](https://forum.inductiveautomation.com/u/Eric_Alvey)\
**Post date:** [March 27, 2024, 8:53pm UTC](https://forum.inductiveautomation.com/t/report-filtering-by-date/88007/2 "2024-03-27T20:53:53Z")

</div>

Your start date and end date get bound to a where clause in your actual SQL query for the report data.

This video should help:

> **[Report Data Tab Video at Inductive University](https://inductiveuniversity.com/videos/report-data-tab/8.1)**
>
> The Data tab on a report allows you to create Data Sources and Parameters. These resources dictate the content of the report.

---

<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:** [March 27, 2024, 9:01pm UTC](https://forum.inductiveautomation.com/t/report-filtering-by-date/88007/3 "2024-03-27T21:01:05Z")

</div>

> [@dcamp1](#):
>
> I made 2 new parameters Begin which is a string and Stop which is a string. I use these 2 parameter to insert a variable DATE ...

That's bad. Keep dates as dates all the way through your project until you need to format them for human readability. It will save you and your successors many headaches.

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [March 28, 2024, 10:36am UTC](https://forum.inductiveautomation.com/t/report-filtering-by-date/88007/4 "2024-03-28T10:36:58Z")

</div>

Thanks for the heads-up!

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [March 28, 2024, 1:30pm UTC](https://forum.inductiveautomation.com/t/report-filtering-by-date/88007/5 "2024-03-28T13:30:43Z")

</div>

I figured this out couple of errors on my part, in my SQL Query.  
Thanks to everyone, all information was greatly appreciated.