Re: scripting confusion

iain macdonnell - N6ML
 

On Fri, Jan 30, 2015 at 12:58 PM, tuck@... [dxlab]
<dxlab@...> wrote:



When I entered "(App_DXKeeper_LotW_QSLRdate > #2015-01-29#)" I did not get what I expected.

Instead, I got almost half my DB. What's wrong?
The "empty" value for that field is #4000-01-01#, so your filter would
match any QSO that has not been confirmed by LotW. Instead, you might
try:

App_DXKeeper_LotW_QSL_Rcvd in ('Y','S','V') and
App_DXKeeper_LotW_QSLRdate > #2015-01-29#

73,

~iain / N6ML

Join DXLab@groups.io to automatically receive all group messages.