search

nehtik / epgp

Automatically exported from code.google.com/p/epgp
0 stars 0 forks source link

Date Conversion Information #495

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
We run about 12-15 raids a week, with at 3 25mans, and we need to parse 
the epgp.lua file and display transactions for everything we do.  
Unfortunately, the date format you use (which we call ID number) is not 
recognized by Excel and we haven't been able to figure out how to 
translate it.  As a result, parsing the huge file is difficult when one 
can't even determine the date of the transactions being recorded.  (We 
spend more time figuring our (guessing) where to start parsing than we 
spend doing the actual parse, lol.)

Could you please give us a formula for translating your date into a 
meaningful format?  It would save us hours every week.

Thank you for your help.

Paste the text surrounded by -EPGP- in Guild Information here:

If this is about http://www.epgpweb.com integration, what is the realm
and region of your guild?

Please provide any additional information below.

Original issue reported on code.google.com by ourconun...@live.ca on 13 Aug 2009 at 5:38

GoogleCodeExporter commented 8 years ago 
This is standard unix timestamp: http://en.wikipedia.org/wiki/Unix_time. 
Seconds past 
the epoch.

Original comment by evlogimenos on 13 Aug 2009 at 5:55

GoogleCodeExporter commented 8 years ago 
Thank you.  After more than a bit of research, and a lot of very strange 
conversion 
formulae, this one seems to work the best, although it doesn't compensate for 
Time 
Zone conversion:

=((epgpDate +((365*70+19)*86400))/86400)-0.41667

It appears to convert accurately, but haven't used it on enough files yet to be 
sure.

Original comment by ourconun...@live.ca on 13 Aug 2009 at 7:52

GoogleCodeExporter commented 8 years ago 
=UnixTime / 86400 + 25569

What you have above is not correct.

Original comment by evlogimenos on 13 Aug 2009 at 8:01

GoogleCodeExporter commented 8 years ago 
Yes, i used that one first but the date seemed off by one day, which was 
corrected 
by the more complex conversion.  Am i missing something?

Original comment by ourconun...@live.ca on 13 Aug 2009 at 10:28

GoogleCodeExporter commented 8 years ago 
The time is in UTC. You need to adjust for your timezone.

Original comment by evlogimenos on 13 Aug 2009 at 10:37

GoogleCodeExporter commented 8 years ago 
Smiles, i had figured as much.  However, how do we do that?  We are GMT -5.

Original comment by ourconun...@live.ca on 14 Aug 2009 at 2:58

GoogleCodeExporter commented 8 years ago 
Subtract 5 hours from the date.

Original comment by evlogimenos on 14 Aug 2009 at 6:27

GoogleCodeExporter commented 8 years ago 
Smiles.. yes, i knew that.  However, i was looking for the formula, lol...  I 
am 
assuming that it would be =UnixTime / 86400 + 25569 -(5/24).  Would that 
assumption 
be correct?

Original comment by ourconun...@live.ca on 14 Aug 2009 at 4:20