Reports-Historian query Timeseries charts not displaying the correct date ranges

[Alex_Jaffe]

I am having a problem with my reports.

I currently have a series of VFD’s and their associated interlocks historized and mapped to a series of timeseries charts. In the designer and preview they seem to be working properly, but I have a schedule to send to an email address and when they arrive, the date range is wrong.

Here is what i have set for my start date/end date/history date setup

here is what the page looks like in preview (what i want it to look like)

Here is what it looks like when it is received as a pdf via email

Instead of the timespan being 24 hr for the previous day, it is the last 3 days. i am not sure what is causing this or why it is different between the preview and pdf.

any help is appreciated, thanks.

[Alex_Jaffe]

also note, I have other reports active that are working just fine when sent to email

[KathyApplebaum]

just a quick comment on your start date expression. It seems like you’re trying to get midnight of the previous day. A cleaner way to do that would be
midnight(dateArithmetic(now(), -1, “day”))

For your end date you can do
dateArithmetic(midnight(now()), -1, “second”)

[Alex_Jaffe]

didn’t realize there was a midnight function, thank you, that will help simplify things

[ryan.white]

For your future referencing:

Expression Functions | Ignition User Manual