More formula help

2 posts / 0 new
Last post
profit814
Offline
Joined: 03/18/2018 - 17:12
More formula help

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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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