Hey @Impala,

Welcome to the Community!

I looked at the screenshot, and it seems like the “canceled date” is being returned as a Unix timestamp. I suggest adding a formatter step after the trigger to convert Unix to a readable date.

Here’s an in-depth tutorial on how to do that:

Please give that a try, and let us know how it goes!

Thanks! 

Hello @ken.a, 

The formatting works well thanks, the output corresponds to the real date but when testing the action to enter the data in airtable, the date of churn is not taken into account and does not appear. Do you have any idea what this could be? Thank you for your answer

Hey there @Impala,

Thanks for giving that a try, and I’m glad it works well!

Before we dig deeper into this, to ensure that we have sufficient context, kindly share detailed screenshots of the Zap History data IN/OUT of the Airtable step. Please don’t/blur out include any personal information in the screenshot.

Thanks! 

Hi @ken.a  ! Thanks for responding, 

Here is my data of the airtable step : all entries work except "Date churn”. Is this the data you need ? Thanks again

Hi @Impala,

I appreciate the screenshot, but it’s not quite the screenshot that I was looking for. I apologize for the confusion. The Data IN/OUT of the Zap should be located in your Zap History: https://zapier.com/app/history

Please include the whole section of the latest Zap Run in the screenshot as well. Here’s an example:

(view larger)

Thanks! 

Hi @ken.a 

There is the screen : the churn date (which one is formatted) doesnt even appear...

Thanks !!!

Hi @Impala,

Thanks for the screenshots!

Based on my observation, it is possible that you are using an older version of Airtable. If you are seeing a version number alongside the app name, it may indicate that you are running an outdated version of the application.

Could you please try changing the Airtable app to the latest version? Here’s how:

1. Turn off the Zap.
2. Click on the “App & event” section of the action step.
3. Click on “Change”.
4. Search for Airtable.
5. Select Airtable tagged as “Latest”.
6. Publish the Zap, and trigger it.

Please give that a try, and let us know how it goes!

Thanks! 

Thanks you @ken.a , I tried but It doesn't work, I have the impression that the output of the formatted date is not transmitted to airtable. 

Im sorry to take your time. 

Hey there @Impala,

No worries at all!

Thanks for giving that a try. One possible reason here is that the “Date churn” field on your Airtable only accepts a certain format of date. Could you please try changing the “To Format” field in the Formatter step, and match the format to the “Date creation” field.

(view larger)

Please give that a try, thanks! 

@ken.a  It works !! Thanks you very much !

Have a nice day

Hey there @Impala,

You are most welcome! I'm happy I could help you out!

If you've got any other questions, don't hesitate to drop them in the Community. We're always happy to lend a hand!