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.
rvnthAccepted solution
Level 5
Dec 1, 2023 10:16 AM UTC

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

4 replies

rvnthAuthorAccepted solution
Level 5
Dec 1, 2023 10:16 AM UTC

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

Translate
ParthaSarathy
Community Advisor
Community Advisor
Dec 1, 2023 10:16 AM UTC

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

 

 

Translate
~  ParthaSarathy S
rvnthAuthor
Level 5
Dec 1, 2023 11:13 AM UTC

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.

Translate
ParthaSarathy
Community Advisor
Community Advisor
Dec 1, 2023 12:30 PM UTC

Both conditions will give the correct output @rvnth !

So you can use any...

Translate
~  ParthaSarathy S