AA6YQ comments below

-----Original Message-----
From: dxlab@... [mailto:dxlab@...]On Behalf Of
Jamie WW3S
Sent: Sunday, October 21, 2012 2:53 PM
To: dxlab@...
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?

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

(qslrdate<>#4000-01-01#) and (qslsdate=#4000-01-01#)

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.

73,

Dave, AA6YQ