Online Express data type of Date becomes a free text field causing incorrect date formats

When including an attribute of Date of Birth as a data type of date, donors can enter free text including dots or dashes as date separators. This can cause the processing of Online Express transactions to fail.
For each transaction that has an incorrect date format, please do the following:
  1. Highlight the transaction generating the error
  2. Click on the transaction information tab
  3. Press F7 on your keyboard 
  4. In the window that appears, manually change the date format to be DD/MM/YYYY (note the slashes)
  5. Click Save and Close
  6. Click Process Transaction
  7. Repeat steps 1-6 for each impacted transaction 

Steps to Duplicate

Steps to Duplicate:
  1. Create a date attribute under Config > Attributes > Participant in The Raiser's Edge
  2. Open an Event Form in Online Express Plugin
  3. Go to Extras tab
  4. Select your date attribute
  5. Open the Online Express form on your browser
  6. Go through the event registration process and when you get to the attribute section, you'll notice the field is free-text. Enter in 14.06.95 for example
  7. Open the Online Express Plugin
  8. Go to Events
  9. Download Transactions
  10. Attempt to process this transaction to a batch - note the error you get
  11. Click on the transaction and go to 'Transaction Information' - note the attribute date is in the wrong format


 Blackbaud Online Express

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.