4 of 4 people found this helpful
Is it possible to configure the DataEndDate string in the source table? If you pass PI Time abbreviations you can easily achieve what you are looking for.
For example if I use T in place of Current Data then set up a Table Lookup Data reference with the following information then I get today at midnight. If you use * you'll get the current time. Would this work for you?
SELECT DataEndDate FROM Test WHERE SiteID = '%Element%'
If you cannot change the input in the table then we can probably work this out using an analysis, let me know if you would need help configuring that, it would not be as ideal as the above example in my opinion.
That worked!! Something so simple...thank you