Skip to Main Content
AVEVA Product Feedback


Status No Status
Categories PI Builder
Created by Guest
Created on Aug 20, 2022

Improve formatting for changedate and creationdate properties in PI Builder Excel Add-in

When querying PI Points within PI Builder we see the changedate and creationdate properties show up in the format "yyyy-MM-dd hh:mm:ss" which is not the default format that Excel wants for filtering and sorting columns by date/time. However, we do see the proper format for these two properties shown after clicking any cell in the same sheet as the PI Point query and hitting "Retrieve". This yields the format "MM/dd/yyyy hh:mm" which is easier to sort and filter through.
  • Attach files