date conversion issue

Question

i am retreiveing records from db on th basis of date ................in DB records avaliable but it's not fetching ...........in MVC 4

Jignesh Kumar · Answer

Plese check below link http://pranayamr.blogspot.com/2012/11/linq-query-to-compare-only-date-part-of.html

Sai Kumar Koona · Answer

Hi Riya, can you make sure to send the date from MVC application to DB in MM/DD/YYYY format? I guess your application hosted server having different date format.

Jenith Thakkar · Answer

Okay CHeck with This p.saledate.Date >= fromdate.Date && p.saledate.Date <= Todate.Date

Riya Singh · Answer

after removing date contion records found ..........but whenever i use date condition records not coming.........

Jenith Thakkar · Answer

Okay First You check with Remove this line from linq query && (p.saledate >= fromdate && p.saledate if you still not found any records then it means there's a no date issue it will be something else

Riya Singh · Answer

Datatypeof SaleDate is in Datetime and fromdate and todate also in datetime format...... model.GetCartData = (from p in db.cartsummary.ToList() join c in db.invoice on p.saleno equals c.saleno where c.dealerid == IntDealerId && (p.saledate >= fromdate && p.saledate select new CartSummary1 { id = p.id, type = p.type, productname = GetProductNameList(p.productid), dealerid=p.dealerid, saleno = p.saleno, customer = p.customer, productid = p.productid, Rate = p.Rate, amount = p.amount, Quantity = p.Quantity, }).ToList();

Jenith Thakkar · Answer

Which Date Format you had pass from MVC?