Help with a SQL query function | Community
Skip to main content
thaiskoliveiras1998
Level 2
April 3, 2024
Solved

Help with a SQL query function

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
_Manoj_Kumar_
_Manoj_Kumar_Accepted solution
New Participant
April 3, 2024

Hello @thaiskoliveiras1998 

 

You an try this

DateOnly(@eventDate) = DateOnly(DaysAgo(6))
     Manoj     Find me on LinkedIn
View reply

1 reply

_Manoj_Kumar_
_Manoj_Kumar_Accepted solution
New Participant
April 3, 2024

Hello @thaiskoliveiras1998 

 

You an try this

DateOnly(@eventDate) = DateOnly(DaysAgo(6))
Translate
     Manoj     Find me on LinkedIn
    Terms & ConditionsAccessibility statement

    Loading footer...