The member's profile include the birthday. Many of the field are contained in engine4_user table. I have explored other engine4_user_fields_*** but can't find the date of birth.
Please help me with this. What is the name of the table with DOB?
I noticed the year can be hidden in 5.4.0. Thanks for this change I requested. I will test it in a little while.
Well there are the values stored in the engine_user_fields_values . It would correspond to the user number and corresponding field id. On my site, the birthday is id 6. The field id can be found in the engine_user_fields_meta.
Thanks Donna for the quick answer. I am not a database expert but I have been able to export the user and the values table to Excel. I then used Excel's Vlookup function to combined the birthdate (or other values) in a single spreadsheet I needed for something else.