# Getting Transition StampTime from Historian

**URL:** <https://forum.inductiveautomation.com/t/getting-transition-stamptime-from-historian/117285>\
**Category:** Ignition\
**Created:** [September 30, 2026, 9:26pm UTC](https://forum.inductiveautomation.com/t/getting-transition-stamptime-from-historian/117285 "2026-09-30T21:26:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pmo](https://avatars.discourse-cdn.com/v4/letter/p/e480ec/32.png) [@pmo](https://forum.inductiveautomation.com/u/pmo)\
**Post date:** [September 30, 2026, 9:26pm UTC](https://forum.inductiveautomation.com/t/getting-transition-stamptime-from-historian/117285/1 "2026-09-30T21:26:18Z")

</div>

I have a customer that is asking for the StampTimes of when a piece of equipment Starts/Stops. They currently have years of this Boolean data stored in Historian.

I am setting them us with a Transaction Group solution for future reporting needs, but does anyone have a good method of finding and reporting the transition times from the historical data of a boolean?

---

<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 30, 2026, 9:48pm UTC](https://forum.inductiveautomation.com/t/getting-transition-stamptime-from-historian/117285/2 "2026-09-30T21:48:48Z")

</div>

My toolkit's `lag()` and `where()` expression functions can be assembled to do that. From a tall output "as stored" binding dataset.

---

<div class="post-metadata">

**Author:** ![pmo](https://avatars.discourse-cdn.com/v4/letter/p/e480ec/32.png) [@pmo](https://forum.inductiveautomation.com/u/pmo)\
**Post date:** [October 1, 2026, 2:44pm UTC](https://forum.inductiveautomation.com/t/getting-transition-stamptime-from-historian/117285/3 "2026-10-01T14:44:23Z")

</div>

Thanks for pointing me down the path to a solution. Probably not the Best but it looks to be working!!!

EDIT - Please ignore the '+1' on row 9, that was my testing and should have been removed....

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/3/7330a1056ae60ddb29f2dd37f1162c4dd424d199.png)