FILTER COLUMN DATE SQL IN POWER AUTOMATE DESKTOP

[fgonzalez515]

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' ??

[Ankesh_49]

@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.

[fgonzalez515]

Hi @Ankesh_49

I try but show me this error "Error in SQL statement Data types mismatch in criteria expression"

[Ankesh_49]

Select *

[Gidi]

the field is date time not date 😉

[Ankesh_49]

@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.

[fgonzalez515]

Hi @Ankesh_49 

I do it to filter the columns I want

[fgonzalez515]

@Ankesh_49 

It shows me the same error, "Error in SQL statement Data types mismatch in criteria expression."

[Ankesh_49 · Accepted solution]

SELECT * FROM [YOURSHEETNAME$]WHERE[Recepcion] between #01-07-2022# and #01-07-2022 23:59:59#