Hi All I am trying to build a query that returns all records from a specific week number. I could not get it to work, so I have narrowed it down to this: SELECT strftime('%W', StartTime, 'unixepoch', 'localtime') FROM Records WHERE strftime('%W', StartTime, 'unixepoch', 'localtime') <> 17; which should return the week number of all records *not* started in week 17. However, it matches 5 records and all 5 returns a week number of 17! Looks like the strftime returns 17 in the SELECT part and something else in the WHERE part. I don't believe that so chances are I am doing something stupid here. Can anyone please tell me how to do this right? Br Morten