Problems making filters in a dashboard

Get Help
1

I made this SQL query and visualised it as a trend but when I saved it and added it to the dashboard the filters don't recognise it saying "A date variable in this card can only be connected to a time type with the single date option."
I'm new to Metabase and SQL so I would appreciate any help
here's the SQL query

SELECT
  source.fldTimeslotDate AS `Date`,
  COUNT(DISTINCT source.fkClientID) AS `New Customers`
FROM
  (
    SELECT
      vw_client_service_timeslot_details.fkClientID,
      MIN(vw_client_service_timeslot_details.fldTimeslotDate) AS fldTimeslotDate
    FROM
      vw_client_service_timeslot_details
    WHERE
      vw_client_service_timeslot_details.fldClientServiceTimeslotStatus = 'Finished'
    GROUP BY
      vw_client_service_timeslot_details.fkClientID
  ) AS source
JOIN tbl_user ON tbl_user.pkUserID = source.fkClientID
GROUP BY
  DATE_FORMAT(source.fldTimeslotDate, '%Y-%m-01')
ORDER BY
  DATE_FORMAT(source.fldTimeslotDate, '%Y-%m-01') ASC;
2

Int hat case you should checkout the docs :slight_smile: ... Gonna be a life saver for you. On the above I would start with the below