I keeping getting this error code. Syntax error at position 12 in '3DAYREMINDER eq ' 10/04/2024'.
inner exception: Syntax error at position 12 in '3DAYREMINDER eq ' 10/04/2024'.
clientRequestId: 8c697a4c-99de-4d86-b162-2d53dcd454f4
I am trying to send a daily automated email from a 3DAYREMINDER column in excel. This is what the whole query looks like that is failing.
3DAYREMINDER eq ' @{formatDateTime(convertFromUTC(utcNow(), 'Eastern Standard Time'), 'MM/dd/yyyy')}
Syntax error at position 12 in '3DAYREMINDER eq ' 10/04/2024'.
Note how your single quotes are misplaced and one is missing.
Should be '3DAYREMINDER' eq '10/04/2024'
Although the column name likely should come without quotes.
Pro tip: Never start a column name with a number.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.