Reformat Donation Date Field In Exported Data - NOT Currently Readable as Date by Excel
The date fields in exported data are not formatted so that Excel can read them as dates. This is REALLY problematic. The imported data cannot be sorted by date without us having to parse ALL the donation_date cells into two separate fields, reformat them as date and time. Surely you can split your own date and time into separate fields, so when we import it, we don't have to.
EXAMPLE: Jul 17 2020 3:25PM EDT
This becomes a Text Field in Excel.
marked this post as