Page 2 of 2

Re: Custom query problem

Posted: 02 Mar 2025, 12:14
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

Re: Custom query problem

Posted: 03 Mar 2025, 11:08
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