in re-reading your initial query - you wanted exactly 15 days ago, or today… updated to accomodate
q: ((column "IssuedTime" of it as string as integer) * second + "01 Jan 1970 00:00:00 -0000" as local time,column "ActionName" of it, column "IssuerName" of it, column "ActionID" of it) of rows whose (((it/day = 0 or it/day = 15) of (now -((column "IssuedTime" of it as string as integer) * second + "01 Jan 1970 00:00:00 -0000" as local time))) AND (column "IssuerName" of it as string does not contain "ServerSigningCertificate") AND (column "ActionName" of it as string does not contain "Subscribe to Site")) of statements ("SELECT IssuedTime,ActionName, IssuerName, ActionID FROM ACTION_HISTORY") of sqlite databases of files "ActionHistory.db" of folders "__Global" of data folders of client