Skip to main content
Question

Formatter (Date/Time) not working consistently

  • February 7, 2022
  • 3 replies
  • 119 views

Hello, i have an automatization that convert date to + 6 month, but any cases doesn`t work correctly, can anyone help me? 

 

I have a good input:

But not good output: 

 

 

 

HOWEVER i have a similar case:

 

Good input: 

Good output: 



 

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

3 replies

GetUWired
Forum|alt.badge.img+12
  • Zapier Solution Partner
  • February 7, 2022

Hi @devopsuser 

Your time format is not HH:mm:ss but H:mm:ss In your first screenshot the time is 9 not 09. 

Try that and see if your results are better. Otherwise, try removing the timestamp entirely and just using DD.MM.YYYY


  • Author
  • Beginner
  • February 10, 2022

@GetUWired thanks for answer! 

I have a case in the same Zap, where without 0 before HH:mm:ss. 
 



What you think about it? 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 10, 2022

@devopsuser 

You may need to add a Formatter > Text > Length step to detect the length of the Date string, then use Paths to handle accordingly.