WP Last Login Data Format

  • Resolved mwolze

    (@mwolze)


    1 year, 11 months ago

    The export file I make has the wp-last-login field, how do I decode that date? In the record i get info like: 1671923954
    Thanks,
    Matt

Viewing 1 replies (of 1 total)
  • Plugin Author Daniel Loureiro

    (@loureirorg)

    Hi, @mwolze.

    This number is a “timestamp”, which is the number of seconds passed since 1/1/1970.

    To convert it to a human-readable date, look online for “excel convert timestamp to date”.

    But in short, that’s how you do:
    1. Let’s say the timestamp is in “G2”.
    2. Insert a new empty column, ex. “H”.
    3. On H2, add this formula: =G2/86400+ DATE(1970,1,1)
    4. You will see the converted date on H2.

    If it doesn’t work, make sure that the cell formats are correct:
    – “Number” for the timestamp column (ex. “G”)
    – “Date” for the date column (ex. “H”)

    I hope this makes sense.

Viewing 1 replies (of 1 total)
  • The topic ‘WP Last Login Data Format’ is closed to new replies.