Skip to main content
Nintex Community Menu Bar
Solved

EPOCH TIME CONVERSION

  • September 22, 2020
  • 2 replies
  • 81 views
  • Translate

Forum|alt.badge.img+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

Best answer by marcwibbs

Hi @butlerj 

 

That's done the trick, thanks very much

 

View original
Did this topic help you find an answer to your question?

2 replies

butlerj
Nintex Employee
Forum|alt.badge.img+20
  • Nintex Employee
  • 260 replies
  • September 23, 2020

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

Translate

Forum|alt.badge.img+3
  • Author
  • Rookie
  • 7 replies
  • Answer
  • September 23, 2020

Hi @butlerj 

 

That's done the trick, thanks very much

 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings