Tell us what you are trying to do?
I added a series of Custom Fields to collect more info when registering for classes.
One of the fields is a date field for Date of Birth.
It used to be a text field and I converted it to a date field with a date picker
The data is collected in the Database like this,
wpcf-child-1-date-of-birth2 26/08/2016
But when I view the Edit User Page
wp-admin/user-edit.php?user_id=XX
The meta field for Date of birth ignores the database value and shows today's date.
I reentered the correct date using the date picker and it is stored in the same manner.
An export of user data shows correctly,
and the Users own profile page shows the right value,
So this is just in the WordPress admin area when I view the user profile page.
Is there any documentation that you are following?
Based on what I see the DOB format in the database would be incorrect.
What should be in the database is a timestamp rather than this text "wpcf-child-1-date-of-birth2 26/08/2016".
What I recommend here is to re save the date field by selecting the correct DOB using the datepicker and then checking to see if a timestamp is being saved to the database.
As per the original post,
I reentered the correct date using the date picker and it is stored in the same manner.
its all good when entered in the form, stored in the db, exported on a spreadsheet and displayed in the Users Profile Page.
Just not in the WordPress admin area for Edit User.
So this having been a text field originally, I have the issue of old dates in one format and the dates themselves in another.
I suspect the options are:
revert to a text field.
go back over every date entry and manually re-enter them. (not likely with hundreds of entries)
or is there another option available??
The field value of "1472169600" is actually correct given that it is now a timestamp.
The only options you have are as you say to either revert the field to a single line field or to go over the records and manually update the values.
I would recommend the latter where you update the fields so they now hold a timestamp as this will help later if you want to filter your users by DOB or order them by their DOB
Right - so I need to find a way to get the right format of each date stamp when exporting too.
As it stands now I'm getting a CSV with 1472169600 instead.
Perhaps that's a job for the WP All Import team? Or maybe you have some suggestions. on how to extract toolset timestamps to CSV?
In this case yes you will need to contact the WP All Imports team to see if they have a solution to parse the data when its being exported.
Thanks,
Shane
