3 of 3 people found this helpful
Check out the syntax and examples in PI Time Expressions and Abbreviations. You can specify the time and offset as mentioned for time in PI.
For example 't' is midnight today. 5 am would be 't+5h' (h is hours, offset of 5 hours)
In your case 't-7d' would be 7 days back from midnight of today. If run today 10 Sep (any time) it would be 3-Sep-2018 00:00
I believe this also answers your other post PI SQL commander query specific time
Thank you so much. This works perfectly.
Also thanks for the link to PI Time Expressions and Abbreviations.