How do I compare date with time to date without time?

Question

0.00/5 (No votes)

See more:

I am using an object objCurrentWarrantStatus to get the database datetime which is #11/3/2016 6:36:49 AM#. I would like to compare it with the date I have in xml document which is <warrantstatusdate>2016-11-03
Xml date does not have time while database date has time in it.
My code is failing for the reason that these two are not of the same type. Comparing #11/3/2016 6:36:49 AM# to 2016-11-03 is not working.
The code I have below is supposed to pass (not generate an error) but since the database date also have time in it I am not able to compare it to the date in xml document because xml document date has no time in it. This is making my code to fail. If I can figure out what to change so these two dates are in the same formate, then my code will not fail.
What do I need to change so that the database date which has time in it and the xml date which has no time in it are in the same format to compare them?

VB

objCurrentWarrantStatus = Msc.Integration.Mncis.Library.v4.WarrantStatus.GetCurrent(Trim(objXMLInputDoc.DocumentElement.SelectSingleNode("msc:WarrantNumber/msc:ID", objXMLNameSpaceManager).InnerText))
        If (Not objCurrentWarrantStatus Is Nothing) _
            AndAlso ((objXMLInputDoc.DocumentElement.SelectSingleNode("msc:CurrentWarrantStatus/msc:WarrantStatusTypeText/@code", objXMLNameSpaceManager).InnerText <> objCurrentWarrantStatus.TypeCodeWord) _
            Or (CDate(objXMLInputDoc.DocumentElement.SelectSingleNode("msc:CurrentWarrantStatus/msc:WarrantStatusDate", objXMLNameSpaceManager).InnerText) <> objCurrentWarrantStatus.Date)) Then
            strErrorResponse = "The date used for CurrentWarrantStatus was incorrect."
            objXMLInputDoc.DocumentElement.SetAttribute("error", strErrorResponse)
        End If

Here is the property for the date

VB

Public Property Date As Nullable(Of DateTime)
	Get
	Set

What I have tried:

I have tried the following code but it is failing because the date in the database (objCurrentWarrantStatus) has time in it while the date in xml document does not have time. So these cannot be compared.

VB

objCurrentWarrantStatus = Msc.Integration.Mncis.Library.v4.WarrantStatus.GetCurrent(Trim(objXMLInputDoc.DocumentElement.SelectSingleNode("msc:WarrantNumber/msc:ID", objXMLNameSpaceManager).InnerText))
        If (Not objCurrentWarrantStatus Is Nothing) _
            AndAlso ((objXMLInputDoc.DocumentElement.SelectSingleNode("msc:CurrentWarrantStatus/msc:WarrantStatusTypeText/@code", objXMLNameSpaceManager).InnerText <> objCurrentWarrantStatus.TypeCodeWord) _
            Or (CDate(objXMLInputDoc.DocumentElement.SelectSingleNode("msc:CurrentWarrantStatus/msc:WarrantStatusDate", objXMLNameSpaceManager).InnerText) <> objCurrentWarrantStatus.Date)) Then
            strErrorResponse = "The date used for CurrentWarrantStatus was incorrect."
            objXMLInputDoc.DocumentElement.SetAttribute("error", strErrorResponse)
        End If

Posted 3-Nov-16 2:23am

Member 11403304

Updated 3-Nov-16 3:30am

v2

Add a Solution

1 solution

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-11-03T02:34:00

Solution 1

According to MSDN: DateTime Structure[^], there is a DateTime.Date property which you can use to extract from a datetime the part which concerns the date.
Something like:

VB

Dim dateWithTime As DateTime = DateTime.Now '' 2016/11/03 12:30
Dim dateWithoutTime As DateTime = dateWithTime.Date '' 2016/11/03

So, you should extract the date part from objCurrentWarrantStatus before comparing it to the one in the XML document.

[Edited]
This may work:

VB

Dim dateWithoutTime As DateTime
If (objCurrentWarrantStatus.Date.HasValue)
   dateWithoutTime = objCurrentWarrantStatus.Date.Value.Date
Else
   '' No datetime value. Something should be decided about the dateWithoutTime variable.
End If

Or better: if you only want the date part in the Date property (which would seem logical), better do that when you retrieve the data from the database.
[/Edited]

Kindly.

Posted 3-Nov-16 2:34am

phil.o

Updated 3-Nov-16 3:35am

v3

Comments

Member 11403304 3-Nov-16 9:06am

Thanks for the help. However I am not sure how to extract the date part from objCurrentWarrantStatus. I do not have a lot of vb.net coding experience.

phil.o 3-Nov-16 9:09am

Since I do not have the code of the sc.Integration.Mncis.Library.v4.WarrantStatus.GetCurrent() method which assigns your variable a value, I cannot say anything else, sorry. I am not even sure this variable is a DateTime structure. Are you storing a DateTime as a string in the database?

Member 11403304 3-Nov-16 9:22am

Here is the WarrantStatus Class.
public static WarrantStatus GetCurrent(string astrWarrantNumber, bool ablnUsePrimaryDatastoreOnly)

And for the date
Public Property Date As Nullable(Of DateTime)
Get
Set

phil.o 3-Nov-16 9:26am

~~I cannot see any datetime, sorry. How do you retrieve that datetime from the database? Where do you store it~~ and how?
Please avoid posting code in comments. Rather use the green "Improve question" button and qualify your question with more relevant code snippets.

Member 11403304 3-Nov-16 9:28am

Okay I will add the code in the question

phil.o 3-Nov-16 9:36am

I updated my answer.

Member 11403304 4-Nov-16 8:28am

Thanks so much for helping me. Your solution worked!

phil.o 4-Nov-16 10:55am

You're welcome.