Hello Colin and others,
The custom-search query "Log Between Dates" was not working.
Looking into the plugin, I found that the select was missing a # after :BOX1:
The correct line should be:
SQL=Select Callsign, Date, STime, Band, Mode from :TABLENAME: Where Date between #:BOX1:# AND #:BOX2:# ORDER BY Date, Stime
Just edit the plugin Dates.
Jack PA3FGJ
Error in plugin pl_Log_Date.wlp
Error in plugin pl_Log_Date.wlp
Hi Jack
Well spotted, and thanks for the correction, you are right!
An interesting thing about dates and the Access database engine, the American date format (MM/DD/YYY) is used by the database jet/SQL when dates are interpreted as a string e.g. when enclosed between "#" thus #01/10/2002# = 10 January 2002, however if you use #31/12/2002# this will be interpreted correctly irrespectively as 31 December 2002 (as there is no month 31 !) however if you use date #10/01/2002# this will be interpreted as 1 October 2002 and not as you would expect even with your system date format set to DD/MM/YYYY or anything else!
Something to watch out for when querying dates in Winlog32.
73 Colin G0CUZ
Winlog32 Author
Well spotted, and thanks for the correction, you are right!
An interesting thing about dates and the Access database engine, the American date format (MM/DD/YYY) is used by the database jet/SQL when dates are interpreted as a string e.g. when enclosed between "#" thus #01/10/2002# = 10 January 2002, however if you use #31/12/2002# this will be interpreted correctly irrespectively as 31 December 2002 (as there is no month 31 !) however if you use date #10/01/2002# this will be interpreted as 1 October 2002 and not as you would expect even with your system date format set to DD/MM/YYYY or anything else!
Something to watch out for when querying dates in Winlog32.
73 Colin G0CUZ
Winlog32 Author