troubleshooting Question

Milliseconds to year, month, day, etc

Avatar of davidw88
davidw88 asked on
Lotus IBM
12 Comments2 Solutions3144 ViewsLast Modified:
Hi Experts,

Here is a question of how to convert milliseconds to human-readable date. In a document there is a field of "UpdatedTime" in milliseconds and the type of "UpdatedTime" is text. Is it possible to convert this milliseconds into year, month, day, hour, minute and second on a view so that it is human-readable? Is there a way to do this with formula? I checked the online Lotus Help and my reference book but I did not find a solution.

Thanks so much.
ASKER CERTIFIED SOLUTION
marilyng

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros