Fellow Tessiturians,
My Membership Update Opera job dies whenever it tries to run due to "Incorrect syntax near 'day'". The command for the job is as follows:
AP_MEMBERSHIP_UPDATE @i_memb_org = 1, @start_dt = '2005-09-01 00:00:00.000', @end_dt = dateadd(day,-1,convert(varchar,getdate(),112))
Any ideas? Everything seems correct, but apparently...not?
Thank you for your assistance.
Obligatory Trivia Biscuit: Just 1,000 words make up 90% of all writing.
You want
dateadd(day,-1,convert(varchar,getdate(),112))
to be
dateadd(dd,-1,convert(varchar,getdate(),112))