Hi I am trying to filter a date column in power automate desktop.
i am getting an error which says Error in SQL type mismatch in criteria expression
What would i be doing wrong
SELECT [full name], [position code],
SUM(IIF([project number] = 'OPERATING EXPENSE', [work codes], 0)) AS opex_hours,
SUM([work codes]) - SUM(IIF([project number] = 'OPERATING EXPENSE', [work codes], 0)) AS capex_hours,
IIF(SUM([work codes]) = 0, NULL, ROUND((SUM([work codes]) - SUM(IIF([project number] = 'OPERATING EXPENSE', [work codes], 0))) / SUM([work codes]) * 100, 2)) AS capex_percentage
FROM [Timesheet Detailed Report$]
WHERE [Work Date] >= DATE() - WEEKDAY(DATE()) - 6
AND [Work Date] <= DATE() - WEEKDAY(DATE()) - 1
GROUP BY [full name], [position code]
