A little OT: Blank date fields in 200LX database


I'm making a 200LX database file for recording medications. One of the fields is "Discontinued", for recording the date which the medication is discontinued.

I'd like to make a subset (F6) that only shows records where that field is blank, i.e. still current.

According to this article, I should be able to use "!*Discontinued" as the SSL expression in order to look for a blank date field:


But when I do that, I just get all records again. The entire expression I'm using is exactly as follows:


Am I misunderstanding their explanation? Database tells me that I'm running version 1.1 - not sure if there are any other versions in different ROM revisions. Also, does anybody know where to find the GENERAL.GDB file referenced in that article? I was searching high and low, but couldn't find it.


I found a copy of GENERAL.GDB finally. (http://super.hplx.net/anonftp/pub/gengdb.zip). There are lots of useful tips in there; I recommend downloading it if you have a 200LX.

Anyway, when filtering that database the same way ("!*Date field") it works fine for the existing records. If I add a new record, it will still show up even if the date field has been filled in. I'm suspicious that it's some sort of weird parser behavior that's unexpected but useful in certain circumstances. Apparently I'm falling outside of those circumstances somehow.

I changed the filter to "Discontinued>{12/31/2099}" and that seems to give acceptable results. I wonder if there's a way to have it filter based on the current date...

Possibly Related Threads…
Thread Author Replies Views Last Post
  Prime: how to detect date format giancarlo 1 1,488 12-02-2013, 11:21 AM
Last Post: Michael de Estrada
  Date/time formats R. Pienne 4 2,214 11-01-2013, 12:43 PM
Last Post: Marcus von Cube, Germany
  How to set the Date.Time etc on a WP34S Harold A Climer 4 1,909 10-29-2013, 09:32 PM
Last Post: FORTIN Pascal
  Date/time programs for the HP 35s R. Pienne 0 1,093 10-03-2013, 02:37 PM
Last Post: R. Pienne
  200LX problem: Insert batteries and get a continuous beep... ideas ? Gene Wright 8 2,740 06-19-2013, 04:52 PM
Last Post: gene wright
  a new variant of the 200LX? robert rozee 1 1,107 06-03-2013, 10:33 AM
Last Post: BShoring
  HP41 Blank formulars for program documentation? Wolfgang 3 1,487 02-15-2013, 11:08 PM
Last Post: Wolfgang
  Date & Time disappear on WP 34S RenĂ© Franquinet 16 5,275 12-10-2012, 08:24 AM
Last Post: Walter B
  Need a relational database for 200LX Dave Britten 11 3,136 08-29-2012, 01:03 AM
Last Post: Pete Wilson
  [41CL] Image Database Monte Dalrymple 9 2,996 07-04-2012, 01:57 PM
Last Post: Kerem Kapkin (Silicon Valley, CA)

Forum Jump: