18
Reformat Donation Date Field In Exported Data - NOT Currently Readable as Date by Excel
under review
A
Andrew Phillips
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.
Activity
Newest
Oldest
Matt Connelly
Hi everyone--we're working on significant updates to our report structure, and this issue will be addressed as part of that. Thank you for hanging in there. I'm aiming to share more news in the coming weeks.
A
Andrew Phillips
Matt Connelly: Thanks. Will be a huge time-saver.
A
Andrew Phillips
This is a CONITNUING issue that is now a year old, with no response. It should a simple code change on your side, to create separate date and time fields. PLEASE... this issue creates un-necessary added work for users.
J
Julie Newman
Has there been any progress in this? I don't really want to go through each and every line in a csv or excel to convert the date and remove the timestamp. Right now there is no way to edit the cells to reflect mm/dd/yyy or any other kind of format.
Kate Hibbert
Julie Newman: It looks like this is being worked on, but in the meantime...
To speed up the edits, I have been using Find and Replace on the whole column, for example:
Find: "Jul "
Replace with: "7/"
Find: " 2020"
Replace with: "/2020"
Note that including spaces in the find is important.
Then you can use the Text function to convert to whichever date format: TEXT(A2, "YYYY-MM-DD")
Matt Connelly
Matt Connelly
under review
Samantha Wetzel
Yes, please!