public static IEnumerable<PrivacyFormData> ViewPrivacyForms(DateTime startDate, DateTime endDate) { string conString = ConfigurationManager.ConnectionStrings["mongoform.write"].ToString(); string collectionName = Constants.DataBaseConstants.CollectionNames.PRIVACYELECTIONS; PrivacyElectionForm pFormRepo = new PrivacyElectionForm (conString, collectionName); IMongoQuery startDatequery = Query<PrivacyFormData>.GTE(p => p.AuditInsertDateUTC, new BsonDateTime(startDate.ToUniversalTime())); IMongoQuery endDatequery = Query<PrivacyFormData>.LTE(p => p.AuditInsertDateUTC, new BsonDateTime(endDate.AddHours(23.59).ToUniversalTime())); return pFormRepo.Select(Query.And(startDatequery, endDatequery)); }