# History binding returns unwanted data point

**URL:** <https://forum.inductiveautomation.com/t/history-binding-returns-unwanted-data-point/96054>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 17, 2024, 8:02am UTC](https://forum.inductiveautomation.com/t/history-binding-returns-unwanted-data-point/96054 "2024-09-17T08:02:58Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 17, 2024, 1:46pm UTC](https://forum.inductiveautomation.com/t/history-binding-returns-unwanted-data-point/96054/2 "2024-09-17T13:46:13Z")

</div>

Ignition's historian doesn't use half-open time spans. You have to subtract one millisecond from the start of the next day before using it in the history binding. Or in queries. (This is also true when using smaller intervals. The end timestamp must be the last millisecond in the last interval.)

See my Tag Report Utility's time span and history query handling in my exchange resource:

> [@Tag Report Utility](https://forum.inductiveautomation.com/t/tag-report-utility/95299):
>
> New resource just uploaded to the Exchange (pending review). Also available here: [https://www.automation-pros.com/TagReportUtility/](https://www.automation-pros.com/TagReportUtility/) I intend to publish at this link as well as in the Exchange going forward. Announcements will be in this topic. (: Highlights: Provides a Perspective Popup View that provides a user interface to system.tag.query() that entirely replicates the functionality of the Designer's Tag Report Tool. Provides a Perspective Embedded View that provides Time Span selectio…

---

_[View the full topic](https://forum.inductiveautomation.com/t/history-binding-returns-unwanted-data-point/96054)._