how to write linq query for comparing date between start & end date

Question

hi Team,

autally my reqiurement is that i can selected start and end dates from DatePicker and i have to compare them such way i.e,

all records records comes in between them are show in datagrid.

my all records are presented in obserable collection list(my list name is ladlelist)

pls send me as possible .

thanks in advance.........................

Answer 1

Here are similar postes

http://stackoverflow.com/questions/1088212/linq-how-do-i-perform-date-comparison-in-a-linq-query

http://stackoverflow.com/questions/214426/how-to-compare-dates-in-linq

Hope that will hellp.

If you ave any question please let me know

 

 

Answer 2

my linq query is that is not working:-

var s = from p in ladlelist
        where p.lf_start <= dpkFromDate.SelectedDate && p.lf_end >= dpkToDate.SelectedDate
        select p;
 datagriname.itemsource=p;

but in Datepicker date format is not supported

Answer 3

but in Datepicker date format is not supported

which format you have for your datepicker. it support date format you can check the format  of the datepicker

Answer 4

no autually i mean to say that in my database list dates  r in like that format "15-06-2011 14:00:45"

but i m not able to compare dates only(like as 6/15/2011) which is come from Datepicker

pls help me to resolve this problem

Answer 5

Did you try DataTime.Compare methode ?

http://msdn.microsoft.com/en-us/library/system.datetime.compare.aspx

Answer 6

hi mohan,

what is data type of If_start.??

if it's datatime you can use Convert.ToDateTime Method

for more about date conversion see following post.

Answer 7

lf_start is date format

i m already trying this Convert.ToDateTime  but this is not working where dates come from datePicker 

Answer 8

how this going to work?

becs i dont wnt to comapre date to returns an integer that indicates whether the first instance is earlier than other but i wanted to those records which comes in between these dates and show into datagrid

Answer 9

becs i dont wnt to comapre date to returns an integer that indicates whether the first instance is earlier than other but i wanted to those records which comes in between these dates and show into datagrid

 

as you are checking the between two dates so you need to check for bigger from one date and lesser from second date

Hope that will help

Answer 10

Here are useful links for changing format of the datepicker

http://stackoverflow.com/questions/477908/how-to-change-date-format-in-silverlight-datepicker-control

 http://social.msdn.microsoft.com/Forums/en-US/silverlightnet/thread/762857be-8195-47b3-ad0b-4b086f8006da#83ffd684-3337-42b8-bca1-f07baff103df

 

this may be also helpful

http://www.telerik.com/community/forums/silverlight/datepicker/datepicker-date-format.aspx

 

Answer 11

i don't understand  pls send me some sample code

 

Answer 12

i don't understand  pls send me some sample code

 

 

try this

  var s = from p in customerList
                    where p.StartDate<= dtpDatePicker.SelectedDate.Value && p.EndDate >= dtpDatePicker.SelectedDate.Value
                    select p;

Hope that will help let me know if you have any question

Answer 13

hi friends,

i m using this code but this is not working

var s = from p in ladlelist where p.lf_start <= dpkFromDate.SelectedDate.Value && p.lf_end >= dpkToDate.SelectedDate.Value

select p;

then i also using this code but this is also not working

var s = from p in ladlelist where p.lf_start <= Convert.toDateTime(dpkFromDate.SelectedDate.Value) && p.lf_end >= Convert.toDateTime(dpkToDate.SelectedDate.Value) select p;

ples help to resolve this problem.

Answer 14

Hi,

I think you should try this:

var s = from p in ladlelist where p.lf_start <=(DateTime) (dpkFromDate.SelectedDate.Value??DateTime.MinValue) && p.lf_end >= (DateTime)(dpkToDate.SelectedDate.Value ?? DateTime.MinValue)
select p;

Because, the SelectedDate is a nullable datetime, so we can't compare between a DateTime and DateTime? directly.