Incorrect date format imported to the system

Chris Li
Chris Li
Second Anniversary Name Dropper Facilitator 1 Blackbaud Certified
in Blackbaud Raiser's Edge NXT®: General Discussions

I got a excel spreadsheet list of records where the dates are in the format of mm/dd/yr, but when I imported the records into Raiser's, some of the record interpreted mm (month) as year. DD (date) as month and yr (year) became day in Raiser's. The incorrected dates are already imported into the system for the fields of ConsCodeDateFrom and ESRDateGrad. Is there anyway to prevent this from happening again? Any quick and efficient way to correct those incorrect dates other than using global change?

Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Chris Li
    If you can provide some more details (the csv text file sample data) and the screenshot of your import setting. This will help diagnose your issue better.

    As for making changes to what's in RE already, your best bet is to use the appropreiate import (i.e. Constituent Code import) to update the record.

  • Chris Li
    Chris Li
    Second Anniversary Name Dropper Facilitator 1 Blackbaud Certified

    @Alex Wong Here's the sample file. RE_20230531_Sample.xlsx

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Chris Li
    Consittuent Code From date is a Fuzzy date, so importing is a little different potentially and it also depends on your windows “regional setting”. So first question is what “region” is the RE server? (if you are hosted by Blackbaud, what country, if you are “self-hosted” where is the RE server hosted?

    e6b445906492fe83608c430e98953d3c-huge-im
  • Chris Li
    Chris Li
    Second Anniversary Name Dropper Facilitator 1 Blackbaud Certified

    @Alex Wong I used the US setting and the short date is mm/dd/yr for my window. I think I know what the problem is now. Thanks

Categories