locked
Date filtering issues in Linq Query RRS feed

  • Question

  • User451775605 posted

    Hi,

    Im facing the probelm in filtering the record using the date criteria. Im having 2 column FromDate and ToDate. 
    Eg: FromDate : 28/04/2011 & ToDate : 11/03/2012 

    If i pass the FromDate as 04/09/2011 and ToDate as 10/09/2011 means i need to get the above the record, but i cant able to the data.

    Query i used date criteria:
    ------------------------------
    [FromDate] >= FromDate.Value && [FromDate] <= ToDate.Value && [ToDate] >= FromDate.Value && [ToDate] <= ToDate.Value

    Can i know the pblm in the above query.

    Thanks,
    Senthil V. 

    Monday, September 5, 2011 2:34 AM

Answers

  • User917796189 posted

    You need to use Lambda Function for that

    if you give me  full query

    i will sort out it and format it

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, September 6, 2011 3:48 AM