Skip to main content
Question

How to transform the Stripe charge created tag into a date?

  • 7 June 2024
  • 2 replies
  • 13 views

Hi,

I want to set up a Zap in order to keep track on the failed payment attempts in Stripe, but I am struggling with the charge date. On which way can I transform the information of the tag (1717194660) into a date?

Is it the right tag I am using, or should you use a different one?

The connection I try to set up is between Stripe and Google sheets.

Thanks a lot!

 

 

 

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

2 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Jozefien 

Zap action: Formatter > Date & Time > Format

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
ken.a
Userlevel 7
Badge +6

Hi @Jozefien,

+1 to what Troy suggested. You need to use a Date / Time in Formatter - Format action to convert the UNIX timestamp to a proper format. Here’s how:

eb017d474aa538cde7eb7ce0cc72f34e.png
(view larger)

Here’s the output:

7eeb66bed0299ee86c405b2c509d3d0f.png
(view larger)

Hopefully, this helps!

Terms & Conditions