Good morning,

I'm trying to pass a value from a form field into a declared variable using the Custom Query Editor in WF. I was following the manual here: https://www.laserfiche.com/support/webhelp/workflow/9.0/en-us/content/resources/Activities/Custom%20Query%20Property%20Box.htm but I might be missing something because I get errors when I tried to use it similarly. 

My code looks like this:

DECLARE @startdate datetime2 =  '2017-10-06'; 
DECLARE @enddate datetime2 = '2018-10-06';  
DECLARE @interval varchar(10) = 'month'

and what I want to do next is replace the startdate with some type of parameter so I'm doing this now

DECLARE @startdate datetime2 = ?; 
DECLARE @enddate datetime2 = '2018-10-06';  
DECLARE @interval varchar(10) = 'month'

and at the bottom I have the Parameter Names field as ? and Type String and Parameter Value to a form field value (see screenshot)

but I get the error as in the second screenshot.

Any guidance on how to properly configure this?

Thank you,

Raul Gonzalez

UPDATE: I see that someone posted the same issue without a clear result here as well: https://answers.laserfiche.com/questions/68098/Having-trouble-with-a-custom-SQL-query-that-works-perfectly-in-Quick-Fields-83-but-reports-an-error-in-Workflow-91?sort=newest