2 of 2 people found this helpful
Here are few things you can check:
1) Is the time on the PI Data Archive node and the client node in-sync? If they are not how big is the time delay?
2) The cell format of the Excel cell is in the same format as in your code ( dd/MM/yyyy HH:mm) ?
3) Is this error thrown only for 1 particular event, one particular tag or is it always thrown?
The time stamp is always in the past, the excel sheet writes data from yesterday and before and always at 00:00 Hrs, so the PI server time is irrelevant...is weird thing.
Got new info from the field.....this error is showing up in just two pc not in all of them...using PI 2016, datalink 2015, office 2010....