Ask Your Question

How to lookup date field w/ null value?

asked 2021-07-01 20:19:58 -0600


I am trying to execute a DQML query to get listings where field "L_ClosingDate" (representing the listings sold date) is either null or greater than 1 year ago.

(L_ClosingDate=2020-07-01T00:00:00+) This is the query for "where L_ClosingDate is greater than 1 year ago".

How do I write the query to also check "or where L_ClosingDate is null" ?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2021-07-02 08:27:42 -0600

I think this should work for you:
You can also start your query with something like this:

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-07-01 20:19:58 -0600

Seen: 115 times

Last updated: Jul 02 '21