Hello Community,
I have a SQL DataTable in Power Automate Desktop, these elements come from an Excel.
How can I filter the column 'Recepcion' for example only '01-07-2022' ??
SELECT * FROM [YOURSHEETNAME$]WHERE[Recepcion] between #01-07-2022# and #01-07-2022 23:59:59#
It shows me the same error, "Error in SQL statement Data types mismatch in criteria expression."
@fgonzalez515 As @Gidi correctly pointed out it’s a date time field. Therefore, if you have control over the data then remove time from it or tweak the query as below giving a range
SELECT * FROM [YOURSHEETNAME$] WHERE[Recepcion] between '01-07-2022' and '01-07-2022 23:59:59'
Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
the field is date time not date 😉
Select *
Hi @Ankesh_49
I try but show me this error "Error in SQL statement Data types mismatch in criteria expression"
@fgonzalez515 Try this
SELECT * FROM [YOURSHEETNAME$] WHERE [Recepcion]='01-07-2022'
Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.