-
Converting A date Function from VBA to SQL
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules