PDA

View Full Version : Converting A date Function from VBA to SQL



Hattonp
03-07-2012, 09:46 AM
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