Open Genevieve-K opened 1 year ago
This issue has been linked to a Canny post: Wrong date when importing donations :tada:
This issue is stale because it has been open 45 days with no activity. Remove stale label or comment or this will be closed in 14 additional days. Note, if this Issue is reporting a bug, please reach out to our support at https://givewp.com/support. If this is a feature request, please see our feedback board at feedback.givewp.com — that’s the best place to make feature requests, unless you’re providing a PR.
User Story
As a admin, I want to export donations and import them in a new site.
Details
The date of donation is sometimes wrong.
Steps to Reproduce
Value 'future' is not part of the enum Give\Donations\ValueObjects\DonationStatus
.Raison
In import-functions.php, the date is defined by:
$post_date = mysql2date( 'Y-m-d', $data['post_date'] );
However, the mysql2date() suppse that the imput format ism/d/Y
if the separator is a slash. So '10/11/2022' becomes '11/10/2022' in the future. And '27/10/2022' is an unexisting date. I suggest to use the format selected in WP settings, withget_option('date_format')
.I worked around by changing the settings before export the donations.