How to fetch data from SQL server with dynamic date

Question

Hi,

I would like to fetch data from SQL Server with SQL statement for power query as below:

Select * from A where transaction date = ‘2022-08–03’.

It works well however if the date will be dynamic which manually entered everyday.

Normally the date is minus 1 day but if today is Monday then will be minus 3 days.

But still prefer to take the date from cell where I enter it manually.

In this case, how should I write it?

Select * from A where transaction date = ?

Thank you!

Answer 1

Hi @Sarah Chen ,

You need tell us the tools you used
It seems that you may need enter the date manually into the T-sql
https://www.youtube.com/watch?v=OTBBX485Fg8

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

declare @dt date    
Select @dt=Dateadd (day,-Case when datename(weekday,getdate())='Monday' then 3 else 1 end ,getdate())  
--print @dt  
Select * from A where transactiondate = @dt  

Answer 3

Thanks!

I am wondering if I can do this way?
Take the date from parameter where I entered manually?

Answer 4

which manually entered everyday.

Entered where? How is the data quried? Which data provider?