4861SQL Server - 'Date' is not a recognized built-in function name.
- Mar 21, 2013I am not sure how to format the last part of this query which comes from
SELECT Max(TITLOC.TitleLocID) AS MaxOfTitleLocID, TITLES.TitleID,
TITLES.CustLName, TITLES.CustFName, TITLES.RecDT, TITLES.TitleID
FROM (TITLES_WARNING_SENT_qry RIGHT JOIN TITLES ON
TITLES_WARNING_SENT_qry.TitleID = TITLES.TitleID) INNER JOIN TITLOC ON
TITLES.TitleID = TITLOC.TitleID
WHERE TITLES_WARNING_SENT_qry.TitleID Is Null
GROUP BY TITLES.CustLName, TITLES.CustFName, TITLES.RecDT, TITLES.TitleID,
I am getting:
'Date' is not a recognized built-in function name.
It is probably something simple but how would I go about converting this
part "HAVING (TITLES.RecDT<Date()-31)" to something SQL Server is happy
[Non-text portions of this message have been removed]
- Next post in topic >>