latest stable versions: v150827 (changelog)

Old Forums (READ-ONLY): The community now lives at WP Sharks™. If you have an s2Member® Pro question, please use our new Support System.

About: Jen Ortiz

Sorry, I've not written a description yet. I'll get to it soon!


Topics I'm Subscribed To

Viewing topic 1 (of 1 total)
Topic Count Last Reply
Site hacked, Need EOT help

By:  Jen Ortiz in: Community Forum

voices: 1
replies: 3

3 years, 1 month ago  Jen Ortiz

Viewing topic 1 (of 1 total)

Topics I've Started

Viewing topic 1 (of 1 total)
Topic Count Last Reply
Site hacked, Need EOT help

By:  Jen Ortiz in: Community Forum

voices: 1
replies: 3

3 years, 1 month ago  Jen Ortiz

Viewing topic 1 (of 1 total)

My Latest Replies (From Various Topics)

Viewing 3 replies - 1 through 3 (of 3 total)
Author Replies
Author Replies
Posted: Friday Nov 15th, 2013 at 11:28 am #61151
Jen Ortiz
Username: JenCP

And if you need the formula for an open office spreadsheet, use:

let’s say cell A2 contains a UNIX timestamp 1341104400, then this formula

=A2/86400+25569

will return a number. And if you format that cell as a date, DD/MM/YYYY HH:MM:SS, then you’ll read a pretty “01/07/2012 01:00:00” there.

Credit goes to:
https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=606

Posted: Friday Nov 15th, 2013 at 9:17 am #61148
Jen Ortiz
Username: JenCP

A friend was able to give me the answer. I am posting it here in case anyone else needs it!
=============

That’s a UNIX epoch time, the number of milliseconds since the official “birth” of UNIX (1/1/1970).

If you are working in an Excel spreadsheet, there are two ways to approach this. You can either use a simple formula

=A1/(60*60*24)+”1/1/1970″

==========

Posted: Thursday Nov 14th, 2013 at 11:52 am #61125
Jen Ortiz
Username: JenCP

I thought I was asking a simple question…

How do you reverse-engineer the wp_s2member_auto_eot_time that looks like:

1386708207

Into something that looks like this:

Tue Dec 10, 2013 8:43 pm UTC

Am I asking the wrong question? Or does one have nothing to do with the other?

Any response is greatly appreciated!

Viewing 3 replies - 1 through 3 (of 3 total)

Old Forums (READ-ONLY): The community now lives at WP Sharks™. If you have an s2Member® Pro question, please use our new Support System.

Contacting s2Member: Please use our Support Center for bug reports, pre-sale questions & technical assistance.