Quote:
How to get date of friday if I am running the query on monday?
I don't understand your problem.
You already know how to go to previous day, with
Getdate()-1
, aka from today the 27, you check the 26.
And you wonder from today the 27, you check the 24, are you unable to count to 3 and get
Getdate()-3
?