Problem when date arrives to google sheet

[Coorve]

What Happen: https://www.loom.com/share/f4b95fc38b314dc5898d6f177e6620ce

when a facebook lead is added and sent to my google sheet, on the date side, the correct date appears for 1 millisecond and then I think it is calculated and gives me other information… I have tried everything but there is no way.

The formula that I apply is this for the date function: {{formatDate(1.dateCreated; “MM.DD.YYYY”)}}

[ManishMandot]

@Coorve This is really straight forward. It is an issue with your Google Sheets Column formatting.

Fix it like this.

Get in touch,
Manish Mandot