Use of String.compare for a varchar field in SAP

SAP HANASAPSAP Basis

Try to use SqlFunctions.DateDiff method overload which requires 3 inputs as follows −

var res = from a in db.Set<table1>()
where SqlFunctions.DateDiff("dd", a.Date, "20161922") >= 0
&& SqlFunctions.DateDiff("dd", a.Date, "20161122") < 0
select a
raja
Published on 14-Dec-2017 10:49:27
Advertisements