How to fetch the date between two values in the split activity? | Community
Skip to main content
C
chandanasa
Level 2
March 21, 2025
Solved

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

  • March 21, 2025
  • 1 reply
  • 602 views

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

 

 

Best answer by ParthaSarathy

@chandanasa , For segment-2:

post code less than 4000 

OR

post code greater than 8999

OR

post code is empty

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
March 21, 2025

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.

 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
C
chandanasaAuthor
Level 2
March 21, 2025

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
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
March 21, 2025

@chandanasa , For segment-2:

post code less than 4000 

OR

post code greater than 8999

OR

post code is empty

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Terms & ConditionsAccessibility statement

Loading footer...