Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.0
-
Fix Version/s: 4.7.23
-
Component/s: None
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Contributed Code
-
Verified?:No
Description
Currently in CRM_Contact_BAO_Query::dateQueryBuilder(), it builds where clause for date field whose value(s) are considered in mysql format (YmdHis). This put a restriction on date columns like civicrm_financial_trxn.trxn_date which stores and operates on ISO format date values.
It can be resolved by introducing $dateFormat parameter for dateQueryBuilder() to format the date to desired.