Inconsistent data issue with connector

Shane Walsh

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?

Smartsheet Date Time.PNG

Excel Date Time.PNG

Dale Murphy

Is that a timezone issue?

Shane Walsh

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.