Possibility to change datatype date to string when defining a filter in worfklow designer?

You could try to use parameters in the READ task to accomplish this

Since DateEntered is a date time field you may have to format of the value to match the format “yyyy-mm-dd-hh.mm.ss.00000 00” for the search to work properly

Scenario 1

@kamnlk Thanks for the response! Is it possible to put in the parameter for the Key Date a Value with <> date (read: i try to get the value that’s not equal to XXX) 

Scenario 2

If not possible, how do u gain this value using filter: the query builder doesnt give us the right to change the datatype date to a string. This is needed as i want to look up the value by using camunda language (see picture). Is there a solution without using parameters in the worfklow designer

Scenario 1:

Its not possible to use <>  with parameters but, You could do something like check the availability of the customer order records and check the result using a gateway and if it does not exist and proceed to do the rest of the tasks

Scenario 2:
Lets Assume that the CustomerNo is 20230810090640 then we could use a filter expression similar to following to get the behavior
Please note this syntax needs to be entered manually to the filter text box as variable substitution is not supported in the query builder

(customer_no = '${CustomerNo}' AND date_entered = to_date('${CustomerNo}','MMDDYYYYHHMISS'))