Skip to main content
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_KumarAccepted solution
Community Advisor
April 3, 2024

Hello @thaiskoliveiras1998 

 

You an try this

DateOnly(@eventDate) = DateOnly(DaysAgo(6))
Manoj  | https://themartech.pro

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
April 3, 2024

Hello @thaiskoliveiras1998 

 

You an try this

DateOnly(@eventDate) = DateOnly(DaysAgo(6))
Translate
Manoj  | https://themartech.pro