Re: need help with sql filter

Dave AA6YQ

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 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.

Dave, AA6YQ

Join { to automatically receive all group messages.