Hi all I get this error
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value
when using the below code. Any ideas please
var longtime = from d in context.DocketT Bs
//where (DateTime.Now.T oString("dd-MM-yyyy HH:mm:ss")) - Convert.ToDateT ime(c.Docket_Da teRaised + ":00") > TimeSpan.FromMi nutes(60)
where (DateTime.Now - Convert.ToDateT ime(d.Docket_Da teRaised + ":00") > TimeSpan.FromMi nutes(2))
// where c.Docket_Status .Equals("Ea")
//DateTime.ParseE xact
// && !(c.Docket_Stat us == "CL" || c.Docket_Status == "Ca")
select new {d.Docket_Numbe r, d.Docket_DateRa ised, d.Docket_Machin e};
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value
when using the below code. Any ideas please
var longtime = from d in context.DocketT Bs
//where (DateTime.Now.T oString("dd-MM-yyyy HH:mm:ss")) - Convert.ToDateT ime(c.Docket_Da teRaised + ":00") > TimeSpan.FromMi nutes(60)
where (DateTime.Now - Convert.ToDateT ime(d.Docket_Da teRaised + ":00") > TimeSpan.FromMi nutes(2))
// where c.Docket_Status .Equals("Ea")
//DateTime.ParseE xact
// && !(c.Docket_Stat us == "CL" || c.Docket_Status == "Ca")
select new {d.Docket_Numbe r, d.Docket_DateRa ised, d.Docket_Machin e};