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

[rvnth]

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

[rvnth · Accepted solution]

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

[ParthaSarathy]

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())

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

[rvnth]

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.

[ParthaSarathy]

Both conditions will give the correct output @rvnth !

So you can use any...