You need to first ensure that your timestamp (date and time) is interpreted correctly by QV. Easiest way is to set the standard timestamp format variable at the top of your script to the format needed.
daystart(LastLogonTime) as LastLogonDateOnly
to create a date only field from your timestamp (time set to 00:00:00).
Hope this helps,
Can you try to ltrim or left functions to acquire date from those log fields and add zero's at the end of that field and name it as new field which helps you to compare.
left(logfield,10) & '00-00-00' as comparefield.
use left (logfield,8) if you are having year as 2 char's
hope this helps and let me know if i got it in a wrong way
look into date funcktions or format funcktions.
You can also go to doc properties, number, and decide the format for each field, but I preffer to bring it already short to save some memory.
Bring date fields as dates.