Avatar

Employee Advisor

DateOnly(@eventDate) is on or after DateOnly(DaysAgo(1)) 

-If today is the 18th, above should get all records from 17th starting at 00:00 TO the moment of the query being ran (today the 18th at 10:26am).

 

DateOnly(@eventDate) is equal to DateOnly(DaysAgo(1)) 

-if today is the 18th, above would only get you records that happened on the 17th (00:00-23:59)