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