First time here? Check out the FAQ!

How to lookup date field w/ null value?

retag add tags

Hello,

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" ?

pliu7702

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

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

Sort by

oldest

newest

most voted

I think this should work for you:
((L_ClosingDate=2020-07-01T00:00:00+)|(L_ClosingDate=.EMPTY.))
You can also start your query with something like this:
((~(L_StatusCatID=|2))|((L_StatusCatID=|2),(L_ClosingDate=2020-07-01T00:00:00+)))