Target records who's start date column is equal to certain days ? | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by rvnth

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

2 replies

R
rvnthAuthorAccepted solution
Level 5
December 1, 2023

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

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
December 1, 2023

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

 

 

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    R
    rvnthAuthor
    Level 5
    December 1, 2023

    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
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    December 1, 2023

    Both conditions will give the correct output @rvnth !

    So you can use any...

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

      Loading footer...