Solved

EPOCH TIME CONVERSION

  • 22 September 2020
  • 2 replies
  • 66 views

Badge +3

I have a workflow where i need to convert epoch time to standard UTC time.

I have created a workflow (maybe too long but it works) where i get today's time, do a date difference calculation in minutes, multiply that too get my milliseconds.

 

9041i6C922EBF0AFB39B6.png

 

It all works  when i convert from a date to epoch time in milliseconds but when i convert the other way around i get the date and time format as follows:

2020-09-22T02:03:00Z

9042iB1B2FAC3AB553D51.png

Does anyone know of a way to convert the date without having the "T" and "Z" letters present, which i understand are for the time format.

 

Cheers

 

Marc

icon

Best answer by marcwibbs 23 September 2020, 17:37

View original

2 replies

Userlevel 5
Badge +19

@marcwibbs I've done some testing with the different date conversions and formats, and the only solution that I was able to come up for stripping off the T and Z was to use the Format Date to String action after I had done all of my conversions.


 




 


Not sure if that will work for your scenario though.

Badge +3

Hi @butlerj 


 


That's done the trick, thanks very much



 

Reply