Re: need help with sql filter
-----Original Message-----AA6YQ comments below
From: dxlab@... [mailto:dxlab@...]On Behalf Of
Sent: Sunday, October 21, 2012 2:53 PM
Subject: [dxlab] need help with sql filter
I screwed something up, I knew I should have backed up the log before I started....I think I can recover what I’m after. I need a SQL filter to show the QSL date received is populated with anything, and qsl sent is blank.....is that possible?
(qslrdate<>#4000-01-01#) and (qslsdate=#4000-01-01#)If you mean filter the log page display to show all QSOs whose "Date Rcvd" item is non-empty and use "Date Sent" item is empty, then use
73,In DXKeeper, 4000-01-01 is used to represent an unspecified date. Any of a QSO's date items that contain 4000-01-01 are displayed as being empty.