Custom query problem

HB9BRJ
Old Man
Posts: 174
Joined: 23 Nov 2014, 10:46
Location: Schaffhausen

Re: Custom query problem

Post by HB9BRJ »

Code: Select all

Select
  callsign,
  name,
  qsodate
From
  Log
Where
   -- example: only QSOs in year 2024
  qsodate >= '2024-01-01'
  AND qsodate < '2025-01-01'
  AND SRx In (10,19)
73, Markus HB9BRJ
F6FLU
Old Man
Posts: 477
Joined: 03 Aug 2015, 15:33
Location: Near Paris
Contact:

Re: Custom query problem

Post by F6FLU »

Many Thanks Markus

The correct request is :

(QsoDate >= '2025-02-22 00:01:00' ) AND (QsoDate <= '2025-02-23 23:59:59')
AND SRx in (06, 10 ,15 ,19 ,25 ,39 ,63 ,65 ,70)

the SRx in is the "astuce" :-)

Thanks again
Dan - F6FLU
Log4OM V2.35.1.0 - Windows 11 - i9-11900K - SSD 512Go - 32 Go
FTdx101D - Hexbeam - Wire dipole 40-30M
https://F6FLU.org
Post Reply