tonyrosen
11-16-2005, 12:41 PM
Which I don't think is anything other than I'm not versed in this stuff well enough ...
Let's say you have two dates (StartDate and StopDate)
'====================================
StartDate = Range("A3") 'assuming it's already a date
StopDate = Range("A4") 'assuming it's already a date
StopYear = Year(StartDate) + 1
AfterThisDate = "12/31/" & StopYear
'====================================
I need to check to see if the StopDate is less than the AfterThisDate ...
Basically:
If StopDate < AfterThisDate Then
'Throw an error
End If
However, it's not calculating unless the dates are equal ... Am I missing something?
Let's say you have two dates (StartDate and StopDate)
'====================================
StartDate = Range("A3") 'assuming it's already a date
StopDate = Range("A4") 'assuming it's already a date
StopYear = Year(StartDate) + 1
AfterThisDate = "12/31/" & StopYear
'====================================
I need to check to see if the StopDate is less than the AfterThisDate ...
Basically:
If StopDate < AfterThisDate Then
'Throw an error
End If
However, it's not calculating unless the dates are equal ... Am I missing something?