Move timestamp field back one day in report table

[bpomerhn]

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.

[Nol]

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

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? [Date Time Picker]

[bpomerhn]

Thanks, but I am specifically advancing my start and end dates by one day using dateArithmetic so I can look at yesterday’s value.

[Nol]

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 to minus a day off your timestamp.

[bpomerhn]

But I don’t know how to do that in a cell using the key functions.

[Nol]

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.

[bpomerhn]

But then how would it be incremented down the rows?