Limit date fields to avoid SQL errors

SQL databases only accept dates between 1/1/1753 and 31/12/9999 so is it possible for Blackbaud to add some hidden verification to date fields to prevent dates preceding 1/1/1753 from being entered by applicants?

This will prevent the 'Application was not considered successfully. Error occurred while saving objects' message when trying to consider the form into GIFTS Online.

  • Guest
  • Mar 20 2018
  • Will not implement
  • Mar 28, 2018

    Admin response

    Thank you for reporting this. For errors and issues like this, we recommend creating a case with our support team so that we can help you troubleshoot the issue. If you're encountering a bug or error in our software, that's the fastest way for that type of issue to get resolved. I've created a bug in our bug-tracking system so we can triage this.

    In the meantime I'm marking this "Will not implement" in the Ideas Portal - please forgive the heavy-handed wording of that. In this case, that's just the best way to say it's "Closed" without deleting it. We will certainly still consider this, we're just going to track it as a bug instead of a suggestion for an enhancement.

    You can contact our support team at any time for updates on this issue or if you encounter other issues like this.

    Thank you!

  • Attach files