# Report designer help

**URL:** <https://forum.inductiveautomation.com/t/report-designer-help/8507>\
**Category:** Ignition\
**Created:** [June 2, 2014, 7:40pm UTC](https://forum.inductiveautomation.com/t/report-designer-help/8507 "2014-06-02T19:40:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dfarnes](https://avatars.discourse-cdn.com/v4/letter/d/ea666f/32.png) [@dfarnes](https://forum.inductiveautomation.com/u/dfarnes)\
**Post date:** [June 2, 2014, 7:40pm UTC](https://forum.inductiveautomation.com/t/report-designer-help/8507/1 "2014-06-02T19:40:20Z")

</div>

It’s always the simple things that get you. Below is a screenshot of a report from the report designer, and another showing the report I get. Also included is the simple query that the report pulls from. Question: how can I get the date/time column to show the time as well as the date? Thanks in advance.

`SELECT * FROM CELL1
WHERE t_stamp >= '{Date Latches/START DATE}'
AND t_stamp <= '{Date Latches/END DATE}'
`

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [June 2, 2014, 8:08pm UTC](https://forum.inductiveautomation.com/t/report-designer-help/8507/2 "2014-06-02T20:08:22Z")

</div>

You should be able to get the format needed by selecting the format tab and selecting, or creating the desired format you want.

---

<div class="post-metadata">

**Author:** ![dfarnes](https://avatars.discourse-cdn.com/v4/letter/d/ea666f/32.png) [@dfarnes](https://forum.inductiveautomation.com/u/dfarnes)\
**Post date:** [June 2, 2014, 8:20pm UTC](https://forum.inductiveautomation.com/t/report-designer-help/8507/3 "2014-06-02T20:20:49Z")

</div>

Greg, thanks much, that was exactly what I was looking for. Sorry to show off my inexperience with the report designer.