Thread

Hi - I have a need to output the raw “join_date” variable for the logged-in member, shown in the original unix timestamp - not the date formatting.

I’ve played with {exp:query} but cannot get it to look for the join_date of the logged-in member. Ex code that doesn’t work:

{exp:query sql="SELECT join_date FROM exp_members WHERE username = '{logged_in_username}' "}

{join_date}

{/exp:query}

This returns nothing, as it cannot read the variable {logged_in_username} inside the query tag.

Similarly, the {exp:member:custom_profile_data} will not give the join_date unless I specify a format—but I don’t need a format.

Any ideas how to render the raw join_date?

Hiya,

You’ll probably need to use some PHP in the template to get what you want here. This should give you what you need. You’ll need to enable PHP in your template set to Input modein order for this to work.

<?php

global $SESS;
$member_username = $SESS->userdata['username'];

?>

{exp:query sql="

SELECT
        join_date
FROM
        exp_members
WHERE
        username = '<?php echo $member_username; ?>'

"}

{join_date}

{/exp:query}

Hope that helps a bit.

Best wishes,

Mark

You’re awesome! I had a feeling PHP may have been the solution, just didn’t know how to access the info like that. Worked perfectly, thank you! I think I owe you a drink 😊

You’re awesome! I had a feeling PHP may have been the solution, just didn’t know how to access the info like that. Worked perfectly, thank you! I think I owe you a drink 😊

No problems. Glad that got it sorted for you.

Hope everything else goes well for you.

Best wishes,

Mark

Thanks for the assist, Mark.

Carlyn, fel free to post again as needed.