Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VB.Net - Easiect Way to Compare Datess With Time

Posted on 2014-03-21
2
Medium Priority
?
185 Views
Last Modified: 2014-03-24
Good Day Experts!

I have the ever popular question about how to compare 2 dates...one is a SQL table date and the other is Date.Now.  

Here is a sample of the SQL table date:
3/21/2014 1:12:29 PM

Date.Now:
3/21/2014 3:42:13 PM

What I need to do is to add 1hr and 20minutes to the SQL table date and then compare it to Date.Now.  

Can you help point me in the right direction?

Thanks,
jimbo99999
0
Comment
Question by:Jimbo99999
2 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 39946268
Your SQL date is retrieved in your .Net application and stored in a DateTime variable?

YourDTVariable = YourDTVariable.AddMinutes(80)

if YourDTVariable < DateTime.Now ...
0
 

Author Comment

by:Jimbo99999
ID: 39946384
Hello...yes, I have it in a variable.  I will try out now.

Thanks,
jimbo99999
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month9 days, 18 hours left to enroll

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question