×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
That date/time is a Unix Timestamp.
In Goanywhere you can just take the timestamp as input to the FormatTimestamp function and output it in any character format you desire.
Something like this may work.
${FormatTimestamp(1325342402619, "yyyy-MM-dd't'HH:mm:ss.S")}
Sometimes I wonder if they don't bless the post until they know an answer.
Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Monday, January 7, 2019 12:47 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Excel date conversion
GoAnywhere exports their dates into something I cannot understand.
I go into "Web Users" and export the list to XML. One person shows up on their screens as
Last Login Date 6/21/12 3:17:08 PM
But on the xml it shows up as
<lastLoginDate>1340306228671</lastLoginDate>
So I am trying to figure out how to convert 1340306228671 into a timestamp in Excel.
Opened up a ticket on their Forum but it takes awhile for the post to get blest so that it can be seen by others.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dekko.com&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=GYVfe7k5MogwSsRr94zbPeTDRJYpFK3WOG9BKFEwK1s&m=nWpPY8ihkv1tXzyav8wbppySBSpAe0RAugxD4dYqL0w&s=tR4aYrqxr0PbHHroqqDlq7OAErkWh2TzFK0fnY9uArU&e=
midrange.com
