Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.11
-
Fix Version/s: 4.7.9
-
Component/s: CiviContribute
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
When exporting a batch of contributions to IIF, the date format is in YYYY/MM/DD format even though CiviCRM is configured to use MM/DD/YYYY as Quickbooks expects. For example
TRNS GENERAL JOURNAL 2016/01/12 Bank MyGroup 75.00 Check
SPL 1 GENERAL JOURNAL 2016/01/12 Program Income:Membership Dues John Doe -75.00 Contribution Amount Check
ENDTRNS
The file shows 2016/01/12 when Quickbooks expects 01/12/2016
Attachments
Issue Links
Activity
Not sure what you mean. The example above is essentially a customer of the organization where I record a contribution from him and when I generate the export batch, the date is in the wrong format. This is the only place that I see the date appearing in this format. As a work-around, I just have defined a macro in a text editor that corrects the field - but that is a bit annoying to have to do every time.
This issue is certainly important, but doesn't quite make the cut for "critical" priority, which unfortunately means the core team isn't going to be working on it anytime soon due to the realities of our capacity. This is where community support is vital. Can anyone step up to push this issue forward through labor or funding?
Thanks
Pradeep Nayak Updated the PR.
Dilip Raj Baral There seems to be still mismatch between expected and actual date format.
Yashodha Chaku It uses the format from `Complete Date` under Localization. However, Joe Murray want's me to solve this issue by adding another field under Localization > Date Formats. (https://github.com/civicrm/civicrm-core/pull/8354/files). I will work on that.
A new PR addressing the issue with better solution.
https://github.com/civicrm/civicrm-core/pull/8441
PR https://github.com/civicrm/civicrm-core/pull/8441 has been merged
Joe Murray have you noticed this problem with any of your customers?