Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Help with a SQL query function

Avatar

Level 2

Hello!

 

I would like your help to understand this function correctly, please: @eventDate > = Days Ago (6) AND @eventDate < Days Ago (5)

 

I want to filter only those who received an email 6 days ago, the first part of the condition wouldn't be enough? The @eventDate < Days Ago (5) would be a security way to guarantee that only users from six days ago will be filtered? Like, six days ago and no number lower than five days? 

 

Thank you in advance!

Thais

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @thaiskoliveiras1998 

 

You an try this

DateOnly(@eventDate) = DateOnly(DaysAgo(6))

     Manoj
     Find me on LinkedIn

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hello @thaiskoliveiras1998 

 

You an try this

DateOnly(@eventDate) = DateOnly(DaysAgo(6))

     Manoj
     Find me on LinkedIn