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

ClintMc · April 26, 2022, 8:37pm

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!

Thanks!

Clint

JimTheMondayMan · April 27, 2022, 5:40pm

No problem.

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

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

Topic		Replies	Views
Parsing date in Google Sheet module How To date-time-functions , google-sheets	5	917	June 5, 2024
Compare date in Google sheet with today's date How To date-time-functions	10	56	October 18, 2024
Formatting dates inside Google Sheets How To google-sheets	8	1136	October 15, 2023
Parsed Dates Still Passing to Google Sheets as Timestamps How To date-time-functions , google-sheets	3	325	September 22, 2023
Date formatting problem in google sheet How To	2	727	December 20, 2023