Filter Query Based on two Date Fields

kobiashi

Registered User.
Local time
Today, 15:15
Joined
May 11, 2018
Messages
258
hi all


im trying to filter a query based on two fields, these two fields are date fields, [DateComp] and [DateCreated]

1619257042820.png


what i would like to do is return all entries when [DateComp] is empty and todays date from [DateCreated]

ive tried to add "IsNull" to the [DateComp] critieria, which returns the entried ok, but when i then add "Date()" to the [DateCreated] it then only displays todays date, irrelevant of the filter on [DateComp].
 
Congrats on finding your solution. Sometimes all it takes is to step away and smell the flowers for a while so you can clear your head. When I am having trouble with my fiction-writing hobby, that strategy also works.
 

Users who are viewing this thread

Back
Top Bottom