Formatting date/time pulled from QBO Metadata when updating a Google Sheet

I’m trying to update a google sheet with date/time which I’m pulling from QBO Metadata create time field. I am trying to format the date before posting it in google sheet but I’m getting a weird date/time posted. It’s not always but happens sporadically.

Hey Baruch_Pappo

By chance, can you please compare the ones with the issue and the ones that are perfectly fine? What I’m suspecting here is that there might be times when the value of that date field is incorrect, it destroys the formatting and the value is not the expected one. Try to also check if you have the correct formatDate() functions and Tokens as I noticed in your screenshots that you have multiple routes.