VBA Text Box Comparison

[kermitforney]

Need to compare the date values in two text boxes . .

Existing Code:

Me!txtToDate = DateAdd("d", 84, Me!txtFromDate)

Basically, I am trying to run a compare based on DATEDIFF. I would like for it to compare the difference between Me!txtFromDate and Me!txtToDate to make sure it is under 84 days. Also, I would like for it to check and make sure that the difference is also a multiple of seven or make sure the DATEDIFF is any multiple of seven up to 84 days.

Not familiar with VBA, but I can edit (paste) like nobody's business. D

 

[PHV]

A starting point:

intDateDiff = Me!txtToDate - Me!txtFromDate
If intDateDiff > 84 Or (intDateDiff Mod 7) <> 0 Then
  MsgBox "wrong date diff"
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886