What is this value in real life? 1542644098703 is the entry in the lastAuthenticated attribute for a user. How would I get mm/dd/YYYY or something more relateable from that value?
Hi @Kevin Paulus
That value is a unix epoch time. You can convert it to a more readable value using any programming / scripting language. For instance, in Groovy:
groovy -e "println new Date(Long.valueOf(args[0])).format('MM/dd/yyyy')" 1542644098703
returns
11/19/2018
Thank you Bruno: I will be using VBA to convert the numbers to a date format. Your answer gets me started in that direction.
An old thread, but this may be helpful for others anyway. I use https://www.epochconverter.com/ to convert epochs to date/time - it detects if the value is in seconds or milliseconds etc and outputs the date/time in GMT and your local timezone.
CCM
It looks like you're new here. Sign in or register to get started.
