web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate SQL "Get rows" filter ...

Power Automate

Unanswered

SQL "Get rows" filter by datetime in a range

(0) Share

Report

Report

Posted on by Dribbler31

Hello everyone,

I'm sorry, if this question has been answered before, but I just read countless threads, while still having no solution.

I'm trying to fetch specific rows inside of a SQL-table, where the value of a datetime column should be in between of today and 14 days from now.

Thank you very much in advance!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
Hi @Dribbler31

The easiest way would be to do a stored procedure with that query and then call it from Power Automate using the "Execute Stored Procedure" action.

The query can be something like this:

select * from <table> where <date time column> between DATEADD(day,-14,GETDATE()) and getdate()

I'm doing the query from memory, so apologies if the syntax is not 100% correct.

Is this what you need?

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. 👍
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No

Join the conversation