string to date field

Hi,
I've tried everything I can think of to get this to work, but no go. No one seems to have posted this on the forum either. What I'm doing is trying to update a user value on profile view.

switch($tid)
{
case $data->{recent_games}[1]->tid:
//$resultDate = strtotime($data->{recent_games}[1]->last_played);
$user->cb_lastactive = $data->{recent_games}[1]->last_played;
$user->store();
$user->cb_lastplayeddate = $data->{recent_games}[1]->last_played;
$user->store();
break;
The first field, cb_lastactive is a DATE field.
The second field, cb_lastplayeddate is a TEXT field.

when the code runs as is, cb_lastactive displays 22/20/9 for the date. cb_lastplayeddate displays 9/22/2011.
variable $data->{recent_games}[1]->last_played is a string, which is why I tried
$resultDate = strtotime($data->{recent_games}[1]->last_played); which will allow the field to be updated in the BROWSER, but the $user->store(); doesn't work. I can't get anything into that date field using that function. HELP!

figured it out, for anyone else that may run in to this issue. For whatever reason, a date STRING is in the wrong order for CB to accept it into a DATE FIELD. So you have to explode it first, then reconstruct it in a format CB will take.

I don't understand.

Is this your code or some code in CB?

My apologies. if you read the first post you see that I was trying to send a string to a CB date field from some code I had modified in a cb plugin, and I couldn't get it right. I could get the field on the tab to show up, but the DATE field wouldn't save until I added that code in the second post. After a lot of trial and error I finally got it to go in there but I had to jack it around to do it. I have no idea why, so I posted my solution to the problem.

busterocaps wrote: My apologies. if you read the first post you see that I was trying to send a string to a CB date field from some code I had modified in a cb plugin, and I couldn't get it right. I could get the field on the tab to show up, but the DATE field wouldn't save until I added that code in the second post. After a lot of trial and error I finally got it to go in there but I had to jack it around to do it. I have no idea why, so I posted my solution to the problem.

Thanks for posting.

I was confused because you posted in the potential bug area of CB.

That's what I assumed it was, because I had to change the format of the date around to get the cb date field to accept it.