# How do I get to only display t\_stamp values based on my reports Start and End date

**URL:** <https://forum.inductiveautomation.com/t/how-do-i-get-to-only-display-t-stamp-values-based-on-my-reports-start-and-end-date/27661>\
**Category:** Ignition\
**Created:** [August 22, 2019, 1:11pm UTC](https://forum.inductiveautomation.com/t/how-do-i-get-to-only-display-t-stamp-values-based-on-my-reports-start-and-end-date/27661 "2019-08-22T13:11:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastian.zanotto](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@sebastian.zanotto](https://forum.inductiveautomation.com/u/sebastian.zanotto)\
**Post date:** [August 22, 2019, 1:11pm UTC](https://forum.inductiveautomation.com/t/how-do-i-get-to-only-display-t-stamp-values-based-on-my-reports-start-and-end-date/27661/1 "2019-08-22T13:11:00Z")

</div>

So I currently have a transaction group that executes every 10 seconds and i want to display the tag values in my report between the start and end date of my report.  
For example if my reports start date is at 12 am and end date at 12pm how would you write a SQL Query to only display the values from all the time stamps between that start and end date.

---

<div class="post-metadata">

**Author:** ![bpreston](https://avatars.discourse-cdn.com/v4/letter/b/4af34b/32.png) [@bpreston](https://forum.inductiveautomation.com/u/bpreston)\
**Post date:** [August 22, 2019, 1:44pm UTC](https://forum.inductiveautomation.com/t/how-do-i-get-to-only-display-t-stamp-values-based-on-my-reports-start-and-end-date/27661/2 "2019-08-22T13:44:32Z")

</div>

in the WHERE part of your query you need to have a part that is similar to t\_stamp between ? and ?. The questions marks you would have to link to your parameters for your reports start and end date. A real basic example of what I’m talking about is using report parameters:

```auto
SELECT *
FROM table
WHERE t_stamp BETWEEN ? AND ?

```

I would try it out in your query browser first to see if you get the results you want. There you would want to put in the actual date/time instead of the ?'s

```auto
SELECT *
FROM table
WHERE t_stamp BETWEEN '2019-08-22 00:00:00' AND '2019-08-22 12:00:00'

```

---

<div class="post-metadata">

**Author:** ![sebastian.zanotto](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@sebastian.zanotto](https://forum.inductiveautomation.com/u/sebastian.zanotto)\
**Post date:** [August 22, 2019, 9:31pm UTC](https://forum.inductiveautomation.com/t/how-do-i-get-to-only-display-t-stamp-values-based-on-my-reports-start-and-end-date/27661/3 "2019-08-22T21:31:33Z")

</div>

Thankyou ill will try this