Skip to main content
Participating Frequently
Oct 25, 2022 1:34 AM UTC
Question

Not Between in these date

Hi everyone, How to query in appian Not between in these date from oct 1 to oct 5, I would like to show data that not between on these date?

3 replies

Inspiring
Oct 25, 2022 4:25 AM UTC

you have to use greater than and less than operator for this type of query. As of now, we dont have any operator for this type of operations.

Known Participant
Oct 25, 2022 6:34 AM UTC

As Deepak said...we dont have any any operator called "not between" write a query using less than oct1 and greater than oct5 u can get related result and display it where you want

harshitb6843
Brainy
Oct 25, 2022 6:53 AM UTC

I would any day suggest to use a combination of two filters rather than using between of any such related operator. 
You can build a logical expression and then add two filters in it. 

  1. Filter 1 - Less than Oct 1
  2. Filter 2 - Greater than Oct 5

Use the same rule input as the value for both of these filter. That way, you should be able to filter the data.