Simple query to get the Friday date of the previous week

Which day is the first day of the week?

If it is Monday, then try a query:

set datefirst 1  
select cast( dateadd(day, -(datepart( weekday, getdate()) + 2), getdate()) as date)  

If it is Sunday, then:

set datefirst 7  
select cast( dateadd(day, -(datepart( weekday, getdate()) + 1), getdate()) as date)  

Please check this out:

https://answers.microsoft.com/en-us/msoffice/forum/all/finding-the-previous-fridays-date-based-on-the/ed8dba7b-b08b-4232-be76-df5d4863a622

Hi，@Bobby P

Try this：

select DATEADD(day, -3 ,DATEADD(week, DATEDIFF(week,0,GETDATE()), 0)) LastFridayStartTime  
select DATEADD(ms,-3,(DATEADD(day, -2 ,DATEADD(week, DATEDIFF(week,0,GETDATE()), 0)))) LastFridayEndTime  

Best regards,
Bert Zhou

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.

The following code will work for you:
--SET DATEFIRST 1;
----SET DATEFIRST 7; ---1--(7 Sunday default)

declare @dt datetime=getdate()  
   
  
 Select Cast(DATEADD(dd, -3-(((DATEPART(dw,@dt)+@@DATEFIRST) % 7)+5) % 7 , @dt) as date)  LastFriday  
  
  
 --SET DATEFIRST 7;