Trouble formatting a date/time field

  • palmerct

    (@palmerct)


    6 years ago

    I’m trying to display the wp_6pnme9_s2member_last_login_time, _ina_last_active_session, and possibly also the wp_6pnme9_s2member_last_payment_time fields in a meaningful way.

    I’ve tried the “Datetime yyyy-mm-dd hh:mm:ss”, “Date yyyy-mm-dd”, and Unix Timestamp options but in every case it displays/exports something like this 10-digit number — 1520216592.

    Apologies if I’m doing something conspicuously stupid here…I’m a newbie with this plugin and WP-:)

    thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author anmari

    (@anmari)

    Have you rebuilt the cache?
    And have you told the plugin that that is a time stamp field ? Ie that the creating plugin has chosen to store the data as a Unix timestamp. – see find field settings.

    Thread Starter palmerct

    (@palmerct)

    Yes, I rebuilt the cache every time I changed the date format to those 3 different options. I’ll root around in the documentation a bit later today for your “find field settings” suggestion. I recently “inherited” this site so I’m not really up-to-speed with your plug-in…as you probably can tell-:)
    Thanks!

    Plugin Author anmari

    (@anmari)

    H Palmer – just look at the amr users settings in the wp admin panel

    Thread Starter palmerct

    (@palmerct)

    Under Plugins->amr users->Settings, I see General, About (4.26), Your user db, and News tabs across the top. What should I be looking for there? I don’t see anything under any of those tabs that says anything relating to “find field settings”.

    Do I perhaps need one of those “Add ons” listed under “User Lists” since we are using the s2member plugin? Or maybe I’m just looking in the wrong section or missing something obvious about being able to see what format that “wp_6pnme9_s2member_last_login_time” field is being stored in.

    The “user_registered” field does display nicely though.

    Plugin Author anmari

    (@anmari)

    Hi Palmer, sorry Ive been out of internet range for two weeks and when I came back didnt realise this was not sorted out.

    In Fields & Nice names define the field as datetime. PLugin should then at least list it with a human recognisable date & time.

    To use other formats in “Configure a list -> Format’, yes you will need amr-users-plus.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Trouble formatting a date/time field’ is closed to new replies.