Converting A date Function from VBA to SQL

[Hattonp]

I have this query from MS Access -
SELECT [Master Query].CALL_NUMBER, DateAdd("d",7-Weekday(Format([ACTUAL_LOG_DATE],"mm-dd-yy"),1),Format([ACTUAL_LOG_DATE],"mm-dd-yy")) AS [Week Ending],

I cannot get this format to work to my select statement in SQL. The idea is to convert [actual_log_date] to the week ending date.

Any suggestions?
Thank you,
Patrick