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!

Best answer by Troy Tessalone

Hi @pfriend33

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

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

+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

+14

Hi @pfriend33

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

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor

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