Date at selecting "SB" in qsls_date in group edit

3 posts / 0 new
Last post
JE8VZK
Date at selecting "SB" in qsls_date in group edit

Early June I exported all QSOs for some months with marked "sent".
But I did not print and send. (mostly "B" marked)
Some days ago, I marked qsl_s blank to UA, and other QSOs "SB" from "B".
I found the date of marked "SB" remained as 2023-06-03. I supposed these qsls_date must be blank. But group edit did not permit blank.
Then I selected 1901-01-01 unavoidably.
I suppose this must be blank when select SB/SMB/SD/SMD etc. Maybe these will be changed when I export next time with marked "sent".

oh1kh
Date at selecting "SB" in qsls_date in group edit

Hi!

Yes, Group edit does not allow empty dates while database itself allows them for all dates except qsodate.
Maybe this should be changed in group edit.

Meanwhile you can do it with QSO list/Filetr/SQL console.
Here I change all qsos between June 1 and July 30 having qsl sent marked as "SB" .

Remember backups before trying !

 

--
Saku
OH1KH

JE8VZK
[Solved] Date at selecting "SB" in qsls_date in group edit

Firstly I could not read the whole of SQL phrase by overlapping of facebook column.
I made browser width more narrow, then I could read the whole phrase.

Hi Saku, I succeeded to change it, kiitojsia paljon. Naturely after closing cqrlog and re-open. Aitomaticaly saving.