How to fetch the date between two values in the split activity?

[chandanasa]

Dear Community!

@ParthaSarathy 

I need to fetch the date in split activity with two segments.

segment 1 - post code between 4000 to 8999

segment 2 - not post code between 4000 to 8999 or post code is null

Thanks

[ParthaSarathy]

Hi @chandanasa ,

In subset-1 of split have condition as,

post code greater than or equal to 4000 

AND

post code less than or equal to  8999

And enable :'generate complement' in General tab. So that records with values between 4000 to 8999 (including the value 4000 and 8999) will be part of Subset-1 and rest all values including post code as null will be part of complement transition.

[chandanasa]

Thank you @ParthaSarathy 

But I need to create two separate subsets for this requirement as per the organization's requirement. Could you please tell me if there is any other way to create a condition in subset 2?

segment 2 - not post code between 4000 to 8999 or post code is null

Thank you

[ParthaSarathy · Accepted solution]

@chandanasa , For segment-2:

post code less than 4000 

OR

post code greater than 8999

OR

post code is empty