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
 
To add to this, I want it to calculate only the weekdays.

Cheers!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DateDiff issue 7
Error -2147352567 (80020009), Access 2007 0
Need help with calculating dates in records 3
how to write condition in a query 1
Access Sub form opens before the main form in MS Access 0
=DateDiff 5
CALCULATED VALUES IN A FORM BASED ON USER DATA INPUT 3
datediff calculation on Access Form 2

Back
Top