EPOCH time

[trancexx]

You are forgiven.

JohnOne has nice avatar. Don't tell him I said that.

[czardas]

Thanks, I won't do it again.

[BaseIT]

Bug?

When you try to convert with _EPOCH_decrypt() the epoch value 1262390399 (1.1.2010) it returns 1.13.2009.

I solved the problem by changing the value 13 to 12 in line 26 :

bug:

$asDatePart[1] = $i_eFactor - 1 - 12 * ($i_eFactor - 2 >= 13)

fixed:

$asDatePart[1] = $i_eFactor - 1 - 12 * ($i_eFactor - 2 >= 12)

Can you tell me the idea behind the 13?

Edited September 6, 2013 by BaseIT

[trancexx]

Yes I can but it's boring to explain .

I'm using >11.

[BaseIT]

In case that i_eFactor is not a float value (should not), >11 and >=12 are the same.

Maybe you could correct your first entry, for those who don`t look at the second page.

[trancexx]

Yes sir!

...as soon as I find two minutes.

[weszzer]

Hi, I have a file extracted to MS Excel 2010, then the my date-column is showing integer = 1417732821397.44 the original time for this is actually 2014/12/05 06:41:0.000, I used different conversion found on the internet using excel  but no luck to convert to the correct time.

Then I found this topic about the epoch time conversion using autoit. Can you guys help me please on how to covert this integer to date as per my example above using autoit.

Appreciate you help guys.

Thank you..

[AndyG]

1417732821397.44 is not 2014/12/05 06:41:0.000 imho

1417732821.39744 is 2014/12/04 22:40:andsomething...

read http://fczaja.blogspot.ca/2011/06/convert-excel-date-into-timestamp.html

Edited December 7, 2014 by AndyG

[weszzer]

Thanks for the link. it works but except for the hour which is 4hours advance..

1418017836357 = 2014/12/08 05:50:36 (should be 01:50:36)

Thank you

[clicked]

This is an excellent discussion.

I learned much about the "unknowability" of exact time by reading the Boost library intro to its date/time module:

http://www.boost.org/doc/libs/1_57_0/doc/html/date_time/details.html

[weszzer]

I got it!

=((A1/1000)/86400)+25569-"4:00"

Thank you!