var projecttaskSearchObj = search.create({
   type: "projecttask",
   filters:
   [
      ["job.subsidiary","noneof","@NONE@"], 
      "AND", 
      ["formulanumeric: {enddate}-{today}","greaterthanorequalto","0"]
   ],
   columns:
   [
      search.createColumn({
         name: "formulatext",
         formula: "'TASK'",
         label: "Type"
      }),
      search.createColumn({name: "internalid", label: "ProjectID/TaskID"}),
      search.createColumn({
         name: "formulatext",
         formula: "case when {status} = 'Completed' then '' else 'ACTIVE' end",
         label: "Project_Status_Code"
      }),
      search.createColumn({
         name: "formulatext",
         formula: "TO_CHAR({startdate}, 'YYYY/MM/DD')",
         label: "Date_from"
      }),
      search.createColumn({
         name: "formulatext",
         formula: "TO_CHAR({enddate}, 'YYYY/MM/DD')",
         label: "Date_to"
      })
   ]
});

I have this search, i want to convert into suiteQL , but i get some error. could anyone please help me?

how far have you gotten? and what error do you get?

post your SQL

yes its done. Thank you