Compare Dates in VBA
vba
Solution
Here's how you can fix your code. Of course it's not the best way to do date calculations, and you'll also have to validate that there is text in the 2 text boxes, and maybe even use `CDate()` to parse the text to date values, but this will work for your current situation.
If DateDiff("d", txtOrderDate.Text, txtRecievedDate.Text) < 0 Then
MsgBox "Incorrect Date, item can't be recieved before order"
else
MsgBox "correct date"
End If
Problem
I have two textboxes with two differents dates, orderDate and recievedDate. The recieved date needs to be entered manually into the form and I want to include the validation that the recievedData should happen after the orderDate, I have tried: ``` If txtRecievedDate.Text < txtOrderDate.Text Then MsgBox "Incorrect Date, item can't be recieved before order" else MsgBox "correct date" End If ``` This doesn't work as for example RecievedDate value is "19/11/2013" and OrderDate value is "20/10/2013" although this would be a correct date this statement only compares the "19" and "20" therefore marking it as incorrect. Is there a way of comparing two dates within textboxes? For this im using VBA Thanks