Death and Syntaxes

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.

Parents Reply Children
No Data