Skip to main content
Question

Why does Zapier add extra zeros to date and time fields?

  • April 26, 2025
  • 5 replies
  • 38 views

Why does Zapier add many 00000’s to the time and won’t separate the date and the time into two separate fields
 

Scheduled Event Start Time Date (accurate) time (NOT accurate)

 

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

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34080 replies
  • April 26, 2025

Hi ​@annoyed new user 

Try adding this Zap action: Formatter > Date & Time > Format

Formatter help: https://zapier.com/apps/formatter/integrations#help


Mohammad_Shahzaib_Nawaz
Forum|alt.badge.img+3

You can set it like this to get this format May 10 2025 15:30:00
Using Formatter by Zapier (Date & Time)
 

 


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 3527 replies
  • April 28, 2025

Hi ​@annoyed new user,
 
We just wanted to see how everything is going with your Zap. Did everyone’s recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.


@Troy Tessalone  ​@JammerS  Does it add an additional step to the flow using a Formatter? I’m using the free version and I’m limited to two steps in my flow. I’m not sold on Zapier at all. I’m simply trying to set basic flows and it won’t work. I appreciate your help!


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34080 replies
  • April 29, 2025

@annoyed new user 

Yes, Formatter steps count as a step in the Zap.

Using Formatter in a Zap that is turned ON requires a Zapier paid plan.

 

The data returned from Calendly is in ISO format. (ISO = International Organization for Standardization)

This is common and it is common to have to use Formatter steps to transform data points.