Tell us what you are trying to do? Import a large existing data set via WP Import All plugin.
There are 'date fields' in the data set, but they're formatted like this: 19500328
Or in plain english: 1950 March 28.
But when imported they show up in Toolset's fields as a completely different date.
The field I'm importing into is set as a 'date' field.
Is there any documentation that you are following? Yes, theirs in regard to importing data. But there's nothing on how to format a date.
Is there a similar example that we can see? hidden link
Hello. Thank you for contacting the Toolset support.
Well - Types date custom field is a special kind of a field that uses timestamps to store the value. So - you need to convert your date string to Timestamp and store it to database.
So - basically you need to prepare a script that convert your date string to untix timestamp and save the timestamp value as associated field value.
Ok, gotacha.
So, if we leave it as a string, is their a way to format it so it's human readable?
We could change the field type from date to number? or.. something else?
Well - you should create a custom field with field type = Date and if you want to import the date value, you need to convert your date string to timestamp.
So - if you are using Types date custom field - it will accept value as timestamp.
Unfortunately - you can not format the date string unless you build some custom shortcode and pass the date string to it and convert it to date object and return the formatted date.
Now, the old ticket link you shared is really old and we can not rely on that. I suggest better to import your date field as string and then build custom shortcode and the custom shortcode should return you formatted date as per your need.
