Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!
SOLVED

Target records who's start date column is equal to certain days ?

Avatar

Level 5

How can I filter audience where they are there in the system for certain days lets say 20days from their start date field?

 

Thank you in advance. 

 

Best,

Revanth

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 5

DateOnly(@columnName) equal to DateOnly(DaysAgo(noOfDays))

View solution in original post

4 Replies

Avatar

Correct answer by
Level 5

DateOnly(@columnName) equal to DateOnly(DaysAgo(noOfDays))

Avatar

Community Advisor

Hi @rvnth ,

Start date means creation date of recipient profile?

AddDays(@created, 20)    -> This will add 20 days from starting date.

So,

DateOnly(AddDays(@created, 20)) equals to DateOnly(GetDate())

ParthaSarathy_0-1701425778290.png

The above condition will result out recipients who got created in your system 20 days ago

 

 

Avatar

Level 5

Thank you for your reply @ParthaSarathy , Actually I am looking for the recipients who are there in the system for 20days based up on their subscription date column , which is the best way to accomplish this ?

 

The one I have added or the above? Please can you explain the difference between these two?

 

Thank you in advance.

Avatar

Community Advisor

Both conditions will give the correct output @rvnth !

So you can use any...