Advanced Report Creator - set criteria of date IS NULL  [SOLVED]

Discuss your general Proclaim related queries here.
coastal_living
Posts: 17
Joined: Mon Sep 27, 2021 11:58 am
Has thanked: 8 times

Advanced Report Creator - set criteria of date IS NULL

Post by coastal_living »

In Advanced Report Creator, how do I specify that I I only want to include Cases where a certain date field is empty / null? :?:

steve
Posts: 470
Joined: Wed Nov 30, 2011 10:20 pm
Been thanked: 120 times

Re: Advanced Report Creator - set criteria of date IS NULL  [SOLVED]

Post by steve »

{datefield.Date} = Fixed Value
e.g.
Image

leave Fixed Value input box blank, and save the selection test.
It will appear in the selection test list as e.g.
fieldname -Date = ?

coastal_living
Posts: 17
Joined: Mon Sep 27, 2021 11:58 am
Has thanked: 8 times

Re: Advanced Report Creator - set criteria of date IS NULL

Post by coastal_living »

Thank you Steve. I had originally left the box blank, but when I saw it populated a ? I wasn't sure it would work, but you're right, and it works. :D