[SOLVED] CB date format issue in code auto action

Hello:

I've a CB field, with date Y-m-d format in comprofiler table, and I want to get it in a auto action code for sinchronyze another database table, where field is varchar(255). Eg:

cb_fechanacimiento, value 1960-01-25

When I do:

$fechanac1=[cb_fechanacimiento];
$fechanac2=[cb:userdata field="cb_fechanacimiento" /];

The two variables are converted to 1934 integer. But, when I put this in a update query:

,$db->quoteName('fechanacimiento') . ' = ' . $db->quote('[cb_fechanacimiento]'),

value goes right to 1960-01-25.

What I want is to get and convert 1960-01-25 to string 25/01/1960 for including this in the query, but I can't

Thanks for your help.

Regards.

The [FIELD_NAME] substitutions are raw database values. They have no formatting or field behavior applied to them. If you want it to display the same way it does on profile you'll need to use [cb:userfield field="FIELD_NAME" /]. See the substitution tutorial below for further usage information.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

Please also note you need to treat substitutions as strings. When defining your variables be sure to surround your substitutions with quotes.

It was the quote. Now it works as I expected:

$fechanac1='';
$fechaconvertida='';
[cb:if cb_fechanacimiento!=""]
$fechanac1='[cb_fechanacimiento]';
$fechaconvertida= date("d/m/Y", strtotime($fechanac1));
[/cb:if]

But in the auto action, this $fechanac3='[cb:userfield field="cb_fechanacimiento" /]'; results in a empty string, I don't know why, but every way the issue is solved.

Thanks!!!