Skip to main content

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!

 

 

 

Hi @Jozefien 

Zap action: Formatter > Date & Time > Format


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!