How do perform an action if the datetime is more than/greater than 30 min

Question

0.00/5 (No votes)

See more:

i have a label that get a returned value as datetime.

i want to state a condition that will look at the time and perform an action if the datetime is more than/greater than 30 min as show in the code below.

thank you.

What I have tried:

C#

lblCompletedLastTime.Text ="Last Completed at "+ dt.Rows[0]["Last_TimeCompleted"].ToString(); // this gets the datetime from the database and returns it to the label
                if (lblCompletedLastTime.Text > 30min)// if the returned datetime is greater than 30min
                {
                   to do xxxxxx
                }

Posted 28-Oct-16 5:50am

Emmablakes

Updated 28-Oct-16 6:09am

Add a Solution

2 solutions

Solution 1

Assuming you mean "if the time is more than 30 minutes ago", and assuming you're storing the value in the database as either datetime or datetime2, then something like this should work:

C#

DateTime lastCompleted = (DateTime)dt.Rows[0]["Last_TimeCompleted"];
lblCompletedLastTime.Text = string.Format("Last Completed at {0}", lastCompleted);

if (lastCompleted.ToUniversalTime().AddMinutes(30) < DateTime.UtcNow)
{
    // Perform the action...
}

Posted 28-Oct-16 6:09am

Richard Deeming

Comments

Emmablakes 28-Oct-16 12:45pm

thank you.

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)

phil.o · Accepted Answer · 2016-10-28T06:12:00

There exists the TimeSpan structure which is exactly what you need:

C#

DateTime completedOn = dt.Rows[0]["Last_TimeCompleted"];
TimeSpan elapsed = DateTime.Now - completedOn;

if (elapsed.TotalMinutes > 30)
{
   // TODO
}

As you can see, you can subtract two DateTime structures and get a TimeSpan structure characterizing the time-difference between them.

Kindly.