how do you format date for comparison to today
I have tried several iterations to compare the date field to CURDATE, CURRENTDATE, NOW and when I attempt to determine if they are equal, I get an error. Does anyone know the proper MYSQL to format for this comparison? case when DATE_FORMAT(`call_date`,'%m-%d-%Y')=CURDATE() then 'Today' when…
