Implement DateDiff inside DateTable.Select RRS feed

  • Question

  • Hi folks,

    I need to make a DateDiff check in my select in order to return specific rows, but it turns out that the DataTable.Select method doesn't supports DateDiff function and I have no idea how to make my check using another method.

    This is less or more what I want do: DataRows[] Rows = MissionsDT.Select(DateDiff(month, PlannedEndDate, ActualEndDate) = 3); - Using Select method to check the diff between PlannedEndDate & ActualEndDate fields.

    I will appreciate if anyone gives me some new idea for the problem.

    Thank you.


    • Moved by Jonathan Aneja -- MSFT Saturday, June 12, 2010 12:38 AM (From:ADO.NET Entity Framework and LINQ to Entities)
    Wednesday, June 2, 2010 3:57 PM

All replies