Ask Your Question
0

How to lookup date field w/ null value?

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

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

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

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

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+)))

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 112 times

Last updated: Jul 02 '21