Donation Export Producing Inconsistent Information
I'm using Wild Apricot to manage the administration of our donations and also using the information collected to complete mail merges in MS Word using the export from Wild Apricot.
However I'm finding that it's exporting information in a format that is not consistent with the exporting from Memberships.
For instance I want to export the Date Paid, Receipt Number & Amount.
The actual date paid is 1st April 2016, but the date paid that is exported presents as 4/1/2016 5:31:19 AM. I don't want the time to be exported and I want the date format to be consistent with my regional settings being dd/mm/yyyy.
Also, when the Amount exports the actual amount is $44.80 however the Amount that is exported is 44.799999999999997. This is annoying to edit and when there's 20 donations in the mail merge it is quicker to manually write in the amounts and dates than reformatting them to be the correct format.
I believe this is a bug.
It seems like Word bug with handling fields formats during mail merge. You can check e.g. this article for help: http://answers.microsoft.com/en-us/office/forum/office_2010-word/date-format-problem-in-mail-merge-word-2010/91e86ec7-1176-e011-8dfc-68b599b31bf5?auth=1
If you still believe that it's a WA bug, please contact our support.
Oleg, Product designer @ Payments team