Question

Formatter (Date/Time) not working consistently

  • 7 February 2022
  • 3 replies
  • 86 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

Userlevel 7
Badge +12

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

@GetUWired thanks for answer! 

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



What you think about it? 

Userlevel 7
Badge +14

@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.