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)

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
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
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
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
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!

Select *

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!

@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