[SOLVED] Date field format in substitutions

Hi, I'm trying to get a date field to display in "jS F Y" format ('28th February 2022') when using substitutions in an article. I have entered this as custom in the field's Parameters>Display and it renders perfectly in the user's profile, but it still only shows the raw value (correct date but as yyyy-mm-dd) in the substution.

I've tried:
[cb:userdata field="MYDATEFIELD" /]
[cb:userdata field="MYDATEFIELD" reason="profile" /]
[cb:userdata field="MYDATEFIELD" format="jS F Y" /]

It works if I create a tab for the date field only and use [cb:usertab tab="TABID" /] substitution, but I'd prefer not to if I can avoid it.

In same article I'm also displaying today's date in same format using:
[cb:date format="jS F Y" /]

...which works nicely

Can you point me in the right direction?

[FIELD_NAME] and [cb:userdata field="FIELD_NAME" /] substitutions are always raw values. You're needing the formatted value which requires the usage of the [cb:userfield field="FIELD_NAME" /] substitution format. So you should be able to just replace your userdata substitution usage with userfield usage and will display how you're wanting. More details regarding this can be found in our substitution tutorial below.

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

Another neat trick is our nested substitutions. Nested substitutions are supported for date substitutions. So something like the below also works for custom formatting at only that location.

[cb:date format="jS F Y" date="[FIELD_NAME]" /]

I'm trying to format the expiry date in a CBSubs mailer. I tried using the syntax you suggested:

[cb:date format="F j, Y" data="[SUBSCRIPTION_EXPIRY_DATE]" /].

but the resulting emails came through as:

[cb:date format="F j, Y" data="06/04/2022" /].

Is there another setting somewhere that I'm missing to format expiry date in a CBSubs mailer?

You are setting "data" and not "date". So just looks like a minor typo. The below should work fine.

[cb:date format="F j, Y" date="[SUBSCRIPTION_EXPIRY_DATE]" /]

Fixed typo in my post above. Sorry about that!

Thank you!