Demo Discussion
Forum Config Examples Contributions Vulnerabilities
  Discussion forum about ELOG  Not logged in ELOG logo
 Back  |  Find  |  Login  |  Help 
icon5.gif   Converting dates from an Excel import into ELOG, posted by Fergus Lynch on Thu Jan 24 13:50:10 2008 
    icon2.gif   Re: Converting dates from an Excel import into ELOG, posted by Fergus Lynch on Thu Jan 24 16:50:16 2008 
Message ID: 65711     Entry time: Thu Jan 24 16:50:16 2008     In reply to: 65710
Icon: Reply  Author: Fergus Lynch  Author Email: flynch@alternativenetworks.com 
Category: Question  OS: Windows  ELOG Version: V2.7.1-200 
Subject: Re: Converting dates from an Excel import into ELOG 

Fergus Lynch wrote:

Hi,

I'm importing an Excel spreadsheet into ELOG through CSV format.  All working fine apart from dates.

Dates are exporting from Excel in the format "day/month/year" so 1st January 2008 is exported as 01/01/2008 in the CSV.

However all dates are displayed in ELOG as "01/01/1970" regardless of the field content, and looking at the raw ELOG data file dates are displayed as numeric's - so for example 01/01/2008 is "1199188800"

Can you tell me how dates are computed/stored in ELOG so that I can do the necessary conversion.

Many Thanks

Fergus

S'ok - looked up the documentation  and have converted Excel dates to ELOG 'seconds since 01/01/1970' and all has come over fine!

 

Thanks

Fergus

ELOG V3.1.5-fe60aaf