1CultureInfo us = new CultureInfo("en-US");
2                        string formatted = DateTime.Now.ToString("G", us);
3                        string hql = string.Format("from Issue where Completed = (:boolvalue) and EndDate < (:datevalue) and DeletedDate is null and AssignedUser = (:userid)");
4                        SimpleQuery<Issue> query = new SimpleQuery<Issue>(hql);
5                        query.SetParameter("datevalue", formatted);
6                        query.SetParameter("boolvalue", false);
7                        query.SetParameter("userid", ((Users)Session["User"]).Id);
8
9                        PropertyBag["issues"] = ActiveRecordBase.ExecuteQuery(query);