K1000 Reporting Date as mm/dd/yyyy 00:00:00
We have custom date fields under our asset types and when running reports with those field selected it reports as mm/dd/yyyy 00:00:00. I would like to remove the timestamp at then end. When running a 30+ page report, that is a LOT of extra 00:00:00 on the page. I've tried editing the SQL with a FORMAT_DATE and CONVERT(VARCAHR but my MYSQL knowledge is not so good. Any help would be greatly appreciated!