filter dates based on a condition
Hi, I am trying to use rule engine to filter rows that has a certain date
Filter all rows for plans 9015 and 90109 and Date = 17Jan2023
I ahev used Date&TimetoString node to convert this date to string
I am trying to use rule engine
$PLANN$ IN (90105,90109) AND $PAYD$ =’ 2023-07-13’ => TRUE
I am trying to exclude a set of rows that belong to plan 90105 and 90109 and have date =17Jan2023’
Please help