Best answer

Date Format From Gmail Gets Day/Year Wrong

I’m trying to extract the year from date component of a Gmail message. In the attached screenshot, the date pulled from Gmail is Jan 12, 2020.

Zapier is seeing this as Jan 6, 2022 though. I checked the drop down for the “From Format”, but all the options are some variation of Jan 6, 2022.

Any ideas how I can do this? All I want to do is extract the year from the Gmail date and then use that year in the next step of my Zap.

Thanks!

icon

Best answer by Troy Tessalone 16 January 2021, 19:35

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 5

+5

Hey @pfriend33,

this seems weird. Did you try testing it with different samples? Is it like this with every sample from gmail mails?

Best Wishes

Userlevel 7

+14

Hi @pfriend33

Try specifying a From Format in the Formatter step, that ought to correct the issue.

I setup a custom date format string and it has done the trick. This is the one I used

ddd, D MMM YYYY HH:mm:ss Z

Thanks everyone!

Sign up