Re: Help with SQL Expression for DXKeeper wanted


Joe Subich, W4TV
 

Mode like 'FT[48]' and QSL_Sent <> 'Y'
If you are looking for QSOs in 2020, try the following:

QSO_Begin >= #2020-01-01 and QSO_Begin < #2021-01-01# and
Mode like 'FT[48]' and QSL_Sent <> 'Y'

73,

... Joe, W4TV


On 2021-04-04 4:31 PM, Gerhard "Gary" Jaeger, DF2RG wrote:
Iain, thanks very much. I will give it a try tomorrow, when I am at the shack computer again.
73 de Gary, DF2RG
-----Urspr√ľngliche Nachricht-----
Von: DXLab@groups.io <DXLab@groups.io> Im Auftrag von iain macdonnell - N6ML
Gesendet: Sonntag, 4. April 2021 21:55
An: DXLab@groups.io
Betreff: Re: [DXLab] Help with SQL Expression for DXKeeper wanted
On Sun, Apr 4, 2021 at 12:37 PM Gerhard "Gary" Jaeger, DF2RG <gary@df2rg.de> wrote:
At the beginning of every year or so, I print out all the cards for contacts, which have not been printed out so far.

I want to print out all the cards for FT4/FT8, which have not been sent out from the previous year. I hope that you get my point.
Perhaps:
Mode like 'FT[48]' and QSL_Sent <> 'Y'
73,
~iain / N6ML

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