Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
 Back  |  Find  |  Login  |  Help 
icon5.gif   Date in CSV and XML in UNIX time, posted by PJ Meyer on Fri Jul 22 03:15:29 2005 
    icon2.gif   Re: Date in CSV and XML in UNIX time, posted by Stefan Ritt on Fri Jul 22 08:56:20 2005 
       icon2.gif   Re: Date in CSV and XML in UNIX time, posted by PJ Meyer on Mon Jul 25 19:15:33 2005 
          icon2.gif   Re: Date in CSV and XML in UNIX time, posted by Stefan Ritt on Mon Jul 25 20:20:18 2005 
             icon2.gif   Re: Date in CSV and XML in UNIX time, posted by PJ Meyer on Mon Jul 25 22:27:06 2005 
                icon2.gif   Re: Date in CSV and XML in UNIX time, posted by Stefan Ritt on Tue Jul 26 09:25:40 2005 
Message ID: 1296     Entry time: Fri Jul 22 03:15:29 2005     Reply to this: 1297
Icon: Question  Author: PJ Meyer  Author Email: pjm@pjmeyer.org 
Category: Question  OS: Windows  ELOG Version: 2.5.? 
Subject: Date in CSV and XML in UNIX time 
Q: How can dates be exported correctly in CSV and XML?
In windows version I'm getting the Unix seconds since 1970.
XML export:
<DATE>Wed Jun 22 08:29:58 2005</DATE>
<Date_Needed>1119384000</Date_Needed>
<Date_Added>1119470400</Date_Added>

the date record added is good and readable, the two user defined dates are Unix and not real useful in Excel.

Same behavior is the CSV file, the date record added is good, the two user defined dates are Unix seconds.

Now when E-log emails the records all the dates are good - ie readable dates.

So what can be done to make all the dates look like dates?
ELOG V3.1.5-3fb85fa6