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

Help with a SQL query function

  • April 3, 2024
  • 1 reply
  • 804 views

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.
Best answer by Manoj_Kumar

Hello @thaiskoliveiras1998 

 

You an try this

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

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))
Manoj  | https://themartech.pro