Sorry I just seen this message now, I ended up deleting it by accident and wondering why no-one responded.
I will try this today. I didn't know there was a seconds() method attached to the date. Will respond back in a couple of hours when I get to work. -- Thanks, Bruce On Mon, Feb 6, 2012 at 4:51 AM, Niphlod <[email protected]> wrote: > hum.... happen_time is a column of db.cash_journal ? > and you want only the records that satisfy the conditions on the > query, and in addition, that the difference in seconds between > happen_time and now is less than "seconds" (259200) ? > > Without a test db I can't confirm, but can you try something along the > way of (db.cash_journal.happen_time.seconds() < > time.mktime(now.timetuple()) - seconds) > > ? -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com
