how to pass the dynamic date within like (1/1/2020...
# suiteanalytics
a
how to pass the dynamic date within like (1/1/2020 , 1/3/2020) in workbook export query in the script. // Query definition var objQ = query.create({type: "transaction"}); // Conditions objQ.condition = objQ.and( objQ.createCondition({"operator":"IS","values":[true],"fieldId":"posting"}), objQ.createCondition({"operator":"WITHIN","values":[{"dateId":"LM"}],"fieldId":"trandate"}), objQ.createCondition({"operator":"ANY_OF","values":["COGS","Expense","Income","OthExpense","OthIncome"],"fieldId":"transactionlines.accountingimpact.account.accttype"}), objQ.createCondition({"operator":"ANY_OF","values":["1"],"fieldId":"transactionlines.accountingimpact.account.custrecord_cost_head"}));
s
Copy code
objQ.createCondition({"operator":"WITHIN","values":["1/1/2020","1/3/2020"],"fieldId":"trandate"}));
a
@Sandii Thank you, It's working.