Expire Date obfuscated.

  • Hey,

    As I was trying to export my users in csv format I noticed the _expire_user_date_ column it’s not in a readable date format. It looks like it is obfuscated. How can get this exported as a readable date?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Ben Huson

    (@husobj)

    _expire_user_date is stored as a timestamp

    Plugin Author Ben Huson

    (@husobj)

    If you have the date exported as a timestamp in a CSV, you can use Excel to convert the timestamp to a date using the following formula, then set the cell to format as a date:

    =(((A2/60)/60)/24)+DATE(1970,1,1)

    (where A2 is the cell with the timestamp)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Expire Date obfuscated.’ is closed to new replies.