DateDiff calculation on form

  • Thread starter Thread starter sunilkeswani
  • Start date Start date
S

sunilkeswani

I have two fields on a form. Start Date and End Date. On the After
Update Event of the End date box, I want a field TXT1 to unhide itself
and become "required", if the difference between Start and End date is
more than 2.

Could someone please help me doing this?

Cheers
Sunny
 
I managed to get the simple difference , but how can I get weekdays?

Private Sub DtSRResolved_AfterUpdate()
If ([StartDate] - [EndDate]) > 2 Then
Combo52.Visible = True
Else
End If
End Sub

Sunny
 
Back
Top