marcwibbs
Forms Fledgling

EPOCH TIME CONVERSION

Jump to solution

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.

 

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

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

0 Kudos
Reply
2 Replies
butlerj
Community Manager Community Manager
Community Manager

Re: EPOCH TIME CONVERSION

Jump to solution

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

 

Screen Shot 2020-09-23 at 7.55.26 AM.png

Screen Shot 2020-09-23 at 7.55.20 AM.png

 

Not sure if that will work for your scenario though.

0 Kudos
Reply
marcwibbs
Forms Fledgling

Re: EPOCH TIME CONVERSION

Jump to solution

Hi @butlerj 

 

That's done the trick, thanks very much

marcwibbs_0-1600875445766.png

 

View solution in original post

Reply