[Xna4life]

so using LINQ attempting to compare 2 values in the DB and select where the date is less than exactly a year today...so anything between 24/1/12 & 24/1/13 will be selected.

So i've got...

  
var FinalRetentionInvoiceDataSourceID =
            (from worksites in db.Work_Sites
             join invoice in db.Invoices on worksites.id equals invoice.Site_Id
             where CurrentInvoiceDate < DateTime.Now.AddYears(-10)
             select worksites).Distinct().ToList();

this is producing a list but its not correct. I've been playing about with the add years but can't seem to get it.. Anyone have any ideas? Thank You

[Atli]

Moved to the .NET forum. I can't see this being in any way jQuery or Javascript related.

[eclipsed4utoo]

CurrentInvoiceDate < DateTime.Now.AddYears(-10)

So you are selecting where CurrentInvoiceDate is less than 10 years ago. Doesn't sound like what you want.

If you want to search between two dates, you need to give both dates to the query.

[AdamSpeight2008]

It's not that hard to create a (generic) function to handle the in between test.

Public Module
<Extension>
Public Function IsBetween(Of T As IComparable(Of T))( Value As T,
                                                 LowerBound As T,
                                                 UpperBound As T,
                       Optional InclusiveLower As Boolean = True,
                       Optionak InclusiceUpper As Boolean = False ) As Boolean
  Return     (LowerBound.ComparedTo(Value) <= If(InclusiveLower,0,-1))
     AndAlso (Value.ComparedTo(UpperBound) <= If(InclusiveUpper,0,-1))
     
End Function
End Module

This post has been edited by AdamSpeight2008: 25 January 2013 - 02:57 PM

[BattlFrog]

If I understand, you want one years worth of invoices? LINQ does not seem to like having date function within its syntax, so just create the starting date in a variable, then pass it in:

DateTime lastYear = DateTime.Now.AddYears(-1);
var query = db.CurrentInvoiceDate.Where(x => x.CreateDate > lastYear).ToList();


And I switched the less than, to a greater than, because you the invoice date to be newer than one year ago. Hope that helps.