FILTER COLUMN DATE SQL IN POWER AUTOMATE DESKTOP

(0) Share

Report

Posted on by fgonzalez515

296

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ankesh_49

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

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Select *

Was this reply helpful? Yes No
Gidi 601 on at

Like (1)

Report
Copy link

Link copied!

the field is date time not date 😉

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ankesh_49

I do it to filter the columns I want

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report
Copy link

Link copied!

@Ankesh_49

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

Was this reply helpful? Yes No
Verified answer

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No