Find empty date column in search

Tiggy626 · 09-24-2018, 07:41 PM

I want to find all books with an empty "Last Checked" column.

I know how to check if the field is today (#lastchecked:=today) but I can't figure out how to find empty fields.

Thanks for any help
Tiggy626

Tiggy626 · 09-24-2018, 07:46 PM

I found the answer in another thread, sorry for wasting everyone's time.

BTW, is there any way to delete one's own posts?

If there was, I could have just deleted my stupid question.

The answer, by the way is #lastchecked:false
Just for anyone who had the same question.

Tiggy626

theducks · 09-24-2018, 08:03 PM

Glad you found it (before we got a chance to help

)

MR Policy is to leave posts. It is nice, when users do come back and say solved (or what they found

), but it is not required.

09-24-2018, 07:41 PM	#1
Tiggy626 Member Posts: 19 Karma: 10 Join Date: May 2018 Device: none	Find empty date column in search I want to find all books with an empty "Last Checked" column. I know how to check if the field is today (#lastchecked:=today) but I can't figure out how to find empty fields. Thanks for any help Tiggy626

09-24-2018, 07:46 PM	#2
Tiggy626 Member Posts: 19 Karma: 10 Join Date: May 2018 Device: none	Never mind I found the answer in another thread, sorry for wasting everyone's time. BTW, is there any way to delete one's own posts? If there was, I could have just deleted my stupid question. The answer, by the way is #lastchecked:false Just for anyone who had the same question. Tiggy626

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I sort a column so 'empty' fields are last?	capnm	Library Management	4	02-07-2017 12:08 AM
search for empty date	BetterRed	Library Management	2	09-30-2016 07:52 PM
Problem copying a date column to other date column	Terisa de morgan	Library Management	13	05-01-2016 03:27 AM
Help with S/R from text column to a date column	belton180	Library Management	2	04-02-2014 05:23 AM
custom date column from two state column	Dopedangel	Library Management	7	01-03-2012 08:20 AM

09-24-2018, 08:03 PM	#3
theducks Well trained by Cats Posts: 29,809 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Glad you found it (before we got a chance to help ) MR Policy is to leave posts. It is nice, when users do come back and say solved (or what they found ), but it is not required.