[SOLVED] DOB and Age

Age display on profile view doesn't require anything further than setting the date field to display as age, but profile edit is going to show as a date selector. This allows age to auto calculate as the years go by.

Yes, but as one can only be of one Type i.e. custom html or date, a more advanced substitution is required to have Date of Birth populate the separate Age field.

Hello, the previous substitution that worked doesn't anymore in the sense that the date format is different.

It is set to dd/mm/yyyy in the original Date Type which is called Date of Birth, Birthday is the Custom Html with the substitution inserted [cb:userdata field="cb_dateofbirth" /]

Also - why is the substitution originally like an image with white background, stands out when behind that is the light grey - see first attachment.

Attached my results




Tried messing around with various settings and nothing works.

Why are you trying to store the age separately? Sorry, I don't understand what you're trying to do. Create a date field and under Parameters > Display set "Profile View Display" to "Age". That's all you need to do. Profile edit will be the month, day, year dropdowns and profile view will be their age. There's no need for substitutions or anything of the sort. If you insist on using substitutions then please read the below tutorial carefully.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb

I'll keep it simple then. Forget about the age thing, either it can't be done or it's too difficult for me to do. From my first few posts I made it clear I wanted to draw the Age from the existing DOB database, your last post was one or the other, not what I was looking for.

Forget about background being white - I fixed it.


All I want to do is ask a User (when they are editing their profile) for their Date of Birth but instead of displaying 'Date of Birth' to display 'Birthday'. It works when I put 'Birthday [value]' into Profile Value Layout. BUT when I use substitutions like this: Birthday: [cb:userdata field="cb_dateofbirth" /] The Date Comes Out In A Different Format as my CB Configuration.This is my one and only issue.

Look I'll work around it, the reason for birthday instead of date of birth is that 'birthday' is nicer and less mechanical. The reason for the substitution is that I want to display member type, country and birthday - all substitutions, in a custom html part of their profile.

Note: Asking for someones birthday and date of birth are different in my opinion.

I'll keep it simple then. Forget about the age thing, either it can't be done or it's too difficult for me to do. From my first few posts I made it clear I wanted to draw the Age from the existing DOB database, your last post was one or the other, not what I was looking for.

In order to utilize the features of a date field like its age display with an external value you'd need to query for the external value using CB Query Field. Next set a date field to the value of the CB Query Field using CB Auto Actions, but that's a bit much just for the DOB which would be easier if it was just stored with their profile data in CB.

You maybe also able to use SQL functions in CB Query Field to calculate the age with CB Query Field as well. See the below for SQL date functions.

dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html

All I want to do is ask a User (when they are editing their profile) for their Date of Birth but instead of displaying 'Date of Birth' to display 'Birthday'. It works when I put 'Birthday [value]' into Profile Value Layout.

You don't need to do this if you're using a Date field. Set the field title to "Date of Birth". Next under Parameters > Display set "Profile View Title" to "Birthday" or if you're using the Age usage you'd set this to "Age".

Birthday: [cb:userdata field="cb_dateofbirth" /] The Date Comes Out In A Different Format as my CB Configuration.This is my one and only issue.

That's because you're using "userdata" substitution, which is raw value and not formatted value. Formatted value is substituted in using the below usage.

[cb:userfield field="FIELD_NAME" /]

This is detailed in our substitution tutorial below.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb