More formula help

profit814

Forums

i keep getting a bad equation error when i run the extraction below. Je date and first are variables and first is a date that is entered in a text box.im thining my isue may be with the input text on the first variable.
 
task.AddExtraction dbName, "", je_date &  " == " & first

Brian Element Thu, 03/22/2018 - 08:56

Hi there, the most probably cause of this is not having double quotes around the variable first as it is a date and dates need to be encapsulated by double quotes.

So try this:

task.AddExtraction dbName, "", je_date &  " == """ & first & """"

That will add the double quotes around the date.  If you are still getting a problem then make sure the variable je_date holds the name of a date field and that first is in the YYYYMMDD format.

Brian