Validate all date fields before saving or updating record

There are many times where FIMS will accept invalid date formats and insert them into the database.  For example, if someone mis-types "12/31/2015" and uses "12/31/0215", this can be seen in the database as "0231-12-15".  

Reports stop failing as Progress DB returns "Invalid Date Format."

Have FIMS validate date fields for a valid date format on all Date-type fields before inserting or updating a record.

  • Guest
  • Mar 30 2016
  • Attach files