It appears that I have worked a few DX stations in CW that I don¡¯t have confirmed or verified.? I am attempting to write a SQL expression that searches for mode of CW and NOT a US QSO and it the QSO was between ?January 1, 2015 and January 1, 2025 (and that part works it is that last part of the expression that I can¡¯t get right).? Anway, this is what I have so far:
?
(mode='CW') AND (DXCCPrefix <> 'K') AND ?((QSO_Begin > #01-01-2015 00:00#) AND (QSO_End < #01-01-2025 00:00#)) AND ((APP_DXKeeper_LotW_QSL_RCVD<>'V') OR (QSL_Rcvd <> 'V'))
?
I don¡¯t get any errors.? I want it to now list only DX stations that have not been verified. ?I realized that is ¡°confirmation¡± but the ¡®V¡¯ appears in the LoTWR or QSLR columns.? Which explains why I have that part at the end. ?I looked at the Help (Log Items) at file:///C:/Ham%20Programs/DXLab/DXKeeper/Help/Items.htm and it shows an item App_DXKeeper_QSL_Verified but I couldn¡¯t figure out what to do with it since it appears one of its values is ¡®V¡¯, but when I tried it as a SQL expression I got an error.? What am I missing?
