Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting Business Days for Report
- Thread starter nivlac
- Start date
- Thread starter
- #2
MichaelRed
Programmer
A Use
Me.txtDeltaDays = DeltaDays(Me.txtStartDt, Me.txtEndDt)
?Obviousl? used on a form where Me.txtStartDt and Me.txtEndDt are textbox controls on a form and they are populated with date formatted strings. In an IDEAL world, these would include some validation code (in the before update event?) to assure the contents of each did -in fact- resolve to valid dates. Other 'niceties' might apply, but simply doing the exercise of building a test form with the three controls and exercising it shoud provide SOME insight.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
Me.txtDeltaDays = DeltaDays(Me.txtStartDt, Me.txtEndDt)
?Obviousl? used on a form where Me.txtStartDt and Me.txtEndDt are textbox controls on a form and they are populated with date formatted strings. In an IDEAL world, these would include some validation code (in the before update event?) to assure the contents of each did -in fact- resolve to valid dates. Other 'niceties' might apply, but simply doing the exercise of building a test form with the three controls and exercising it shoud provide SOME insight.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question
