B123
(Brian Wattson)
August 16, 2024, 4:25pm
1
Hi
Does anyone know how to set up a rule to highlight a row in a grid when a date field is empty/null? I can get it to work for any other type of field except dates!
According to the manual, you need to set it up like this (leave the value blank) but it doesn’t work:
From the manual:
Thanks
kve
(Kevin Veldman)
August 16, 2024, 5:38pm
2
I think I got around this once by using “Not Greater than 1/1/1975” or some date earlier than any in our database.
1 Like
itsme
(Rhythem Prajapati)
August 16, 2024, 7:48pm
3
What @kve suggested works great !
I have tried putting NULL before and it worked. Maybe give it a shot?
B123
(Brian Wattson)
August 19, 2024, 8:02am
4
Thanks for the suggestions.
I’ve already tried the NULL settings but didn’t work. Tried again - same story.
Kevin - your suggestion seems to work well!
Thanks!
dcamlin
(David Camlin)
August 19, 2024, 12:30pm
5
I recently found that “Contains ” Null may work for you. Test it out and see.
Change your operator… Try CONTAINS a value of null
[image]
Result:
[image]