# Reporting 7.8 date error

**URL:** <https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093>\
**Category:** Ignition\
**Created:** [January 22, 2016, 1:41am UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093 "2016-01-22T01:41:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![heybales](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/heybales/32/3358_2.png) [@heybales](https://forum.inductiveautomation.com/u/heybales)\
**Post date:** [January 22, 2016, 1:41am UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/1 "2016-01-22T01:41:18Z")

</div>

I’m getting the following warnings when running a report.

WARN: Ending date {StepFinish} for tag history in report Report could not be parsed as a date.  
WARN: Using Historical date range, but could not parse {StepSTart} in Start Date field.

The query is a historical tag query nested in a SQL query. The parent returns start and end times for a batch, and the historical query gets the temperature during the batch time. StepStart and StepFinish are columns in the parent query.

The interesting thing is that the report gives the desired graph with correct start and end dates.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 22, 2016, 6:04pm UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/2 "2016-01-22T18:04:16Z")

</div>

I’m not having much luck replicating this.

What version of 7.8 reporting are you running (including build number)?

How is your StepStart column defined in the database? (Date? Timestamp? Datetime?)

---

<div class="post-metadata">

**Author:** ![heybales](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/heybales/32/3358_2.png) [@heybales](https://forum.inductiveautomation.com/u/heybales)\
**Post date:** [January 25, 2016, 9:39pm UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/3 "2016-01-25T21:39:45Z")

</div>

7.8.0 (b2015101414)

mysql DATETIME

I see 7.8.1 is released today. I’m going to install that and see if I get a different result.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 25, 2016, 10:15pm UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/4 "2016-01-25T22:15:48Z")

</div>

Still not able to replicate it with 7.8.0. If you still have issues with 7.8.1, you should contact support, since there seems to be something going on here that’s particular to your set up that I’m not seeing.

---

<div class="post-metadata">

**Author:** ![heybales](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/heybales/32/3358_2.png) [@heybales](https://forum.inductiveautomation.com/u/heybales)\
**Post date:** [January 25, 2016, 10:21pm UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/5 "2016-01-25T22:21:49Z")

</div>

Same result with 7.8.1. I’ll contact support.

I’m also experiencing an error in the viewer. My report is 10 pages, but when I scroll in the viewer, page 2 of 10 is identical to page 1. All 10 pages are. When I save to pdf, I get the expected 10 pages of report.

---

<div class="post-metadata">

**Author:** ![bfearnow](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfearnow/32/3337_2.png) [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\
**Post date:** [March 7, 2016, 3:55pm UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/6 "2016-03-07T15:55:39Z")

</div>

I am having the same date issue. Was there a resolution? Thanks!

---

<div class="post-metadata">

**Author:** ![heybales](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/heybales/32/3358_2.png) [@heybales](https://forum.inductiveautomation.com/u/heybales)\
**Post date:** [March 9, 2016, 1:18am UTC](https://forum.inductiveautomation.com/t/reporting-7-8-date-error/11093/7 "2016-03-09T01:18:55Z")

</div>

It turns out my problem is that the parent dataset contains Null values for DATETIME if the step hasn’t been started or finished. So, the reporting software is correctly reporting a failure to process the child query.

My issue is that I need to generate the report while the batch is in process. I’d like to not return errors, but empty graphs, or even no graph.

I haven’t gotten to looking for a solution to that. Kathy, is there a way to suppress the error messages?
