I would recommend fixing your data so all date fields use the same display format.