[SOLVED] Formating date field in article with cb content bot

Hi again,

I am using the CB content bot to produce personnalized articles and it works fine, including substitutions and conditionnal replacements.

I am encountering a difficulty with a date field :
- it's OK to personnalize the ""today" date [cb:date format="d/m/Y" /]
- but I cannot give the d/m/Y format to a date from database called with substitution [cb_date_paiement]
---- no problem to get the raw SQL field which is Y-m-d formatted
---- I tried almost all combinaisons coming from this page www.joomlapolis.com/documentation/18353-using-substitutions-throughout-cb including [cb:userdata field="[cb_date_paiement]" /] and [cb:userfield field="[cb_date_paiement]" /] with and without several kind of formatting rules like format="Y-m-d" / included in the substitution string - none of them worked
---- I looked across forums but without any idea.

Thanks a lot by advance if you can explain me the trick I probably have missed.

Best regards,
Antoine

[cb:date format="PHP_DATE()_FORMAT" /] strictly only accepts PHP date() function formats. It also strictly only formats the current datetime. If you want to output a date or datetime field formatted you need to use [cb:userfield field="FIELD_NAME" /] otherwise [FIELD_NAME] is raw database value. So for example in your case you'd have the below.

[cb:userfield field="cb_date_paiement" /]

Thanx a lot for your answer - unfortunately I already tried (and tried once again after your reply) but it didn't work :

Code of the article : Mode de paiement : [cb:userfield field="cb_date_paiement" format="d/m/Y" /]

Display : Mode de paiement : [cb:userfield field="cb_date_paiement" format="d/m/Y" /]
which means my way of doing thing is obviously not working.

I'm certainly missing something... the question is what ?

Thanx by advance.

Code of the article : Mode de paiement : [cb:userfield field="cb_date_paiement" format="d/m/Y" /]

Display : Mode de paiement : [cb:userfield field="cb_date_paiement" format="d/m/Y" /]
which means my way of doing thing is obviously not working.

No where in the substitution tutorial does it say you can do this. When using [cb:userfield field="FIELD_NAME" /] for a date or datetime field it will output in whatever format is configured in the field it self. You can not reformat it from a substitution.

krileon wrote:

Code of the article : Mode de paiement : [cb:userfield field="cb_date_paiement" format="d/m/Y" /]

Display : Mode de paiement : [cb:userfield field="cb_date_paiement" format="d/m/Y" /]
which means my way of doing thing is obviously not working.

No where in the substitution tutorial does it say you can do this. When using [cb:userfield field="FIELD_NAME" /] for a date or datetime field it will output in whatever format is configured in the field it self. You can not reformat it from a substitution.

OK - I missconfused the two ways of typing - sorry for that. Things get clearer, tanks !

Unfortunately, what you're recommanding [cb:userfield field="cb_date_paiement" /] displays nothing (blank output).
So I can use only the raw output [cb_date_paiement] which is a SQL date, with the format yyyy-mm-dd.

Any idea why the [cb:userfield field="FIELD_NAME" /] does not work ?

Best regard,

Unfortunately, what you're recommanding [cb:userfield field="cb_date_paiement" /] displays nothing (blank output).

For userfield substitutions the fields access is respected. This means the field needs to be set to display on profile and be on an accessible tab. If you don't actually want it visible on profile then move the tab to a not shown on profile position so the substitution can still display the fields on that tab.