Getting Google Sheets to recognize Date (from Gmail) as a Date

Hey All – new Maker here so probably an easy question.

I have a Scenario where I’m pulling data from Gmail with Text Parser modules and then creating rows in Google Sheets.

My challenge is I’m using the “Date” field from the Gmail Module and when it is written to Google Sheets I can’t get it to be formatted as Date/Time.

Sample: 2022-04-26T00:26:52.000Z

Something I’ve missed no doubt, but if anyone has a point in the right direction that would be amazing!




No problem.

Use the formatDate() function to put the date into a format the Sheets understands, e.g.:

formatDate(1. Date;YYYY-MM-DD)

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Is the System Down or is it just me?
Contact me directly here: Contact – The Monday Man

1 Like