How to code to display between two dates

Question

0.00/5 (No votes)

See more:

Hi, i want to display information from database using the date given. i want to specify the information is between the two dates stated in the view

but i get the error in the query saying that
"Operator '>=' cannot be applied to operands of type 'TimeSpan?' and 'DateTime'"

datestart and dateend is from the input form

What I have tried:

var query2 = (from c in db.Information
                            where c.Time_start >= DateStart && c.Time_start <= DateEnd
                            select new DetailBundle
                            {
                                Time_start = c.Time_Start
                            }).ToList();
            ViewBag.datepick = query2;

Posted 13-Jul-20 22:58pm

dlnzki

Updated 13-Jul-20 23:25pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2020-07-13T23:25:00

You can't compare a Timespan and a DateTime - that like trying to work out the larger of an egg and the theory of relativity.

So check the types of Time_start (which is probably a TimeSpan?) and DateStart (which I suspect is a DateTime) - and either convert the Timespan to a DateTime or vice versa.

Which you chose is going to depend on what you are trying to do, and we don't know that - unless DateStart and DateEnd are the same day then you have a problem as a TimeSpan doesn;t have a "fixed start point" and you can't really say it's between two dates at all.
Think about it: is "09:00" between 1st Feb 1990 and 3rd Aug 2021? It appears once every day, but that isn't really helpful ...

Richard MacCutchan · Accepted Answer · 2020-07-13T23:25:00

Solution 2

C#

where c.Time_start >= DateStart

These two operands are different types as clearly noted in the error message. You need to change one of them so they are the same, both DateTime or TimeSpan types.

Posted 13-Jul-20 23:25pm

Richard MacCutchan