We are using Bonita 7.6.1 with MySQL, and recently realised that the date fields/data are stored as character string/varchar inside the business database? How do we do date-based queries on the business database now?
Anyone has faced/solved this issue please reply.