Skip to main content
Question

Formatter (Date/Time) not working consistently


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: 



 

Did this topic help you find an answer to your question?
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 Expert
  • 1030 replies
  • 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
  • 6 replies
  • 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
Forum|alt.badge.img+14
  • Zapier Expert
  • 31067 replies
  • 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.