Skip to main content
Nintex Community Menu Bar
Solved

EPOCH TIME CONVERSION

  • September 22, 2020
  • 2 replies
  • 115 views

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

 

2 replies

butlerj
Nintex Employee
Forum|alt.badge.img+20
  • Nintex Employee
  • 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.


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

Hi @butlerj 

 

That's done the trick, thanks very much