Solved

VB.Net - Easiect Way to Compare Datess With Time

Posted on 2014-03-21
2
175 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 500 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

776 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