make date filters work. Note: we still need to deal with the offset between the stored data (gmt/utc) and the localtimezone for queries like this.