Displaying Age in Delimiter Fields

I am trying to display age in delimter fields.

I already have cb_dateofbirth field which is set to display on profiles as "Age in years".

However when I create a delimiter field and place [cb_dateofbirth] in the delimiter field, i get the actual date of birth shown in "yyyy-mm-dd"

Is there a way I can display the age meaning that a way to code in the delimiter field such as:

[today's date] - [cb_dateofbirth] = age

User is ([today's date] - [cb_dateofbirth]) years old?


Just to tell you what I am trying to do so you can assist me better.

I am actually to do is to interpret age. For example:

[cb:if cb_dateofbirth=>"30" and cb_dateofbirth>="50"]Age is high risk.[/cb:if]

but because cb_dateofbirth is showing as date, I may have to use:

[cb:if cb_dateofbirth=>"1981-01-01" and cb_dateofbirth>="1951-01-01"]Age is high risk.[/cb:if]

If use the code above, i will need to change the dates either daily or yearly.

I hope you get what I mean.

Please see the below substitution usage tutorial.

www.allmysocials.com/directory/tutorials/item/233-substitution-usage

[FIELD_NAME] is always raw output, no formatting. For what you're wanting simply use the below.

[cb:userfield field="cb_dateofbirth" /]

As for IF statements you'll be comparing against the full date range and may need to use CB Query Field to query the database and calculate the age so you can use the age it self in your IF comparison.

Thanks! When I compare to a full date range, where joomla or cb store it's current date or time (system time)?

Second question, if I were to use auto action plugin, do I use the [cb:user field="cb_dateofbirth"] equal to function as a condition? Will it work?

When I compare to a full date range, where joomla or cb store it's current date or time (system time)?

Don't understand the question. CB/Joomla doesn't store current datetime anywhere. You can substitute current datetime using the below.

[cb:date format="PHP_DATE()_FORMAT" /]

Please see the below tutorial for further substitution usage information.

www.allmysocials.com/directory/tutorials/item/233-substitution-usage

Second question, if I were to use auto action plugin, do I use the [cb:user field="cb_dateofbirth"] equal to function as a condition?

Sure, if you want to condition on age instead of date.

Will it work?

Yes, it should.

Sort to bother you again. How do I trigger an auto action for cb_date = today? I would like to trigger an action if the stored date = today..

Configure your CB Auto Action as normally then supply the below conditional.

Conditional 1: [cb_date] Equal To [cb:date format="Y-m-d" /]

The above should do the trick.