# Move timestamp field back one day in report table **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [December 18, 2025, 7:25pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901 "2025-12-18T19:25:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bpomerhn](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@bpomerhn](https://forum.inductiveautomation.com/u/bpomerhn)\ **Post date:** [December 18, 2025, 7:25pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/1 "2025-12-18T19:25:17Z")
Ignition Perspective 8.1.47 I am looking at yesterday’s flow and elapsed time totalizers in a report table. The timestamp is for the following day (day when I am looking back at the data). Is there a way to move the the timestamp one day back? I tried a superfluous tag historian query and using that timestamp in the row and it didn’t work. Would only give me the same day for all rows. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [December 18, 2025, 7:30pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/2 "2025-12-18T19:30:24Z")
IIRC There was a bug in the date picker being off by 1 day that was resolved in 8.1.49. Before you edit the timestamp, be sure you're actually grabbing the correct day and it's not just pointed to one day off. > [@Perspective Date Time Picker taking value one day back](https://forum.inductiveautomation.com/t/perspective-date-time-picker-taking-value-one-day-back/112839): > > In the Perspective Date Time Picker component, the selected date and time is coming one day earlier than what is chosen in the component. Even though I select the correct date and time, the value received is shifted back by one day. I have attached a screenshot of the Date Time Picker configuration from the Designer. How can this issue be fixed? ---
**Author:** ![bpomerhn](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@bpomerhn](https://forum.inductiveautomation.com/u/bpomerhn)\ **Post date:** [December 18, 2025, 7:40pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/3 "2025-12-18T19:40:27Z")
Thanks, but I am specifically advancing my start and end dates by one day using dateArithmetic so I can look at yesterday’s value. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [December 18, 2025, 7:44pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/4 "2025-12-18T19:44:38Z")
Ohh, my bad I thought you meant it was showing the timestamp as wrong and you were just trying to fudge it to be correct. To take a timestamp and shift it you can use the [dateArithmetic function](https://www.docs.inductiveautomation.com/docs/8.3/appendix/expression-functions/date-and-time/dateArithmetic) to minus a day off your timestamp. ---
**Author:** ![bpomerhn](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@bpomerhn](https://forum.inductiveautomation.com/u/bpomerhn)\ **Post date:** [December 18, 2025, 7:58pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/5 "2025-12-18T19:58:41Z")
But I don’t know how to do that in a cell using the key functions. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [December 18, 2025, 8:09pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/6 "2025-12-18T20:09:52Z")
You should be able to go to the data tab and then make a new parameter and put the dateArithmetic function in there to get the new date you want. Then you use that new parameter name as the key in your report. ---
**Author:** ![bpomerhn](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@bpomerhn](https://forum.inductiveautomation.com/u/bpomerhn)\ **Post date:** [December 19, 2025, 7:07pm UTC](https://forum.inductiveautomation.com/t/move-timestamp-field-back-one-day-in-report-table/112901/7 "2025-12-19T19:07:08Z")
But then how would it be incremented down the rows?