I am trying dimension: tdate { type: date sql: DATE_FORMAT(${TABLE}.“TDATE”,’%m/%d/%Y’) ;; } but not getting output

Hi, I am trying to display only those records as result in looker dashboard in which my date is ‘2020-05-05 00:00:00.00’ from DB but i am getting result for where date is ‘2020-05-05 01:32:18.00’. I have filter the date field. I want result only for ...