Hubspot date format returns same date

Hi ​@hilltop 

For us to have more info, you will need to post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible in the CONFIGURE tab.

Hi ​@Troy Tessalone,

Thank you for the response. Here I am sharing all the screenshots with the details.

This is the whole flow:

Here is the configuration for the formatter, we are taking date from the Arrival Date field from HubSpot:

We are using this output in the slack message. 
Please let me know if you need any more details :)

Thank you again for looking into this.

​@hilltop 

Screenshots do not show these Zap steps are configured:

• Step 3
• Step 4

This is step 3, same as step 2 but for departure field.

And this is step 4

​@hilltop 

For live Zap Runs, check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot: https://zapier.com/app/history/

In step 2 and step 3 you, it is best practice to set the From Format.

You’ll want to set it to UNIX aka X. (see screenshot)

But the output timestamps from HubSpot are in milliseconds, whereas the UNIX (aka X) format option is in seconds.

You can add this Formatter step to convert from milliseconds to seconds: Formatter > Numbers > Perform Math Operation (Divide by 1000)

Units differ:

• Seconds → 10 digits (sometimes shown like 1137971045.0).

• Milliseconds → 13 digits (e.g., 1765065600000 in your screenshot — that’s 2025-12-07 00:00:00 UTC).

Hi there ​@hilltop 👋 Did Troy’s suggestion do the trick?

Want to make sure this gets solved, so please keep us posted on how it went. Happy to lend a hand if you’re still stuck at all! 🙂