Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-16824

Unrecognized date format in custom fields during import of contributions

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.4
    • Fix Version/s: 4.6.5
    • Component/s: CiviContribute
    • Labels:
      None
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      I had to import contributions from a CSV file, and I configured some custom fields for contributions, whose one is a check date whose the format is Date (this is different from the Received payment date).

      During the import, some dates were not recognized because my file has dd/mm/yyyy dates and CiviCRM expected mm/dd/yyyy dates (problem with e.g. 16/03/2010), despite the fact I correctly selected dd/mm/yyyy on the first step of the import process.

      On the third step of the import process I had no error (=dates were recognized), but the errors came only the the fourth step (actual import). When I verified the imported contributions, months and days were exchanged (2 April becames 4 February).

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              seb35 Seb35
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 30 minutes
                30m
                Remaining:
                Remaining Estimate - 30 minutes
                30m
                Logged:
                Time Spent - Not Specified
                Not Specified