Inconsistent data issue with connector

I am using the 'Right(Created at, 5) formula to return the time a record was created. However, the output in excel via the data connector is not the same?


  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    Is that a timezone issue?

  • I think ut could be... as the way they manage the created date, Date & Time is based on their server and when the push that info then via the data connector it isn't processed the same way as on on the front end we see in the application.

    There is also another complication in that sometimes it does revert to the correct display and then flips back so even if you hard program in a resolution that doesn't work either. It appears they have attempted to address it but have done so unsuccessfully.