Date format mixup with buddypress

Today I found at the logs section 4 lines which say the time and then CRITICAL Mismatch Columns. I mapped 4 fields and get 4 mismatch errors for every user which registers. Why they are throwing this error if the fields mapped correctly to buddypress instead of the mix up with the day and month reported above?

Hi @locker17,

Thanks for writing in,

For the date field, you can change the format from the Field Options > Advanced Settings > Date Format. Please refer to the screenshot in the link below for reference.

https://prnt.sc/ywlePpXPVWN_

Regarding the ‘column mismatch’ issue, will it be possible for you to send us the log file? You can use the following tools to create a URL and share us with the log file.

https://encl.io

We will then look into it and get back to you accordingly.

Regards!

Thanks for the answer. I know how to change the format. Unfortunately your plugin doesnt work the same like the buddypress plugin. As shown in the attached picture buddypress plugin shows the date format as d/m/Y – how I wanted it – but saves it as year-month-day in the database (mysql date format).

Your plugin is also beeing able to save it as year-month-day but shows it in the same way which is confusing in my country. I need it show as d/m/Y from the date picker and THEN save it as year-month-day in the mapped buddypress xfield. Then other buddypress plugins can work with it correctly.

Is there a way to fix that?

https://ibb.co/rbZ2qCR

Regarding the column mismatch. I think the log were written because I did not have all options at your plugins dropdown list which I have at the buddypress one. When I correct that, there is no more log. So this one is solved I think.

Hi @locker17

In that case, you can use the following filter to change the date format saved in the database.

add_filter( 'user_registration_validate_date', 'ur_format_date_field', 10, 4 );
 
function ur_format_date_field($single_form_field, $data, $filter_hook, $form_id) {
 
   // Change format of the date
 
}

In the frontend, you can use the desired date format i.e. d/m/Y. I hope this helps.

Regards!

Hi @locker17

Since we haven’t heard from you in a while, I’m going to go ahead and conclude this thread for now. However, if you have any further questions or if there’s anything else we can assist you with, please feel free to continue the conversation.

Regards!

Could you give me some more information how to change the format?
Do I need to use date() and how to save?