hi i have a query which should work however it returns nothing.
i have at least 2 entries where completed = No and the date of the task is today.
the code is:
SELECT count(TaskID) AS DueToday, DATE_FORMAT(`TaskDueDate`,'%d.%m.%Y') AS XLABEL FROM tasks WHERE 'XLABEL' = CURDATE( ) AND Completed = 'No'
however it returns 0
TaskDueDate column in the database is a datetime type that is why i am using dateformat to only display the date of the column as opposed to the date and time.