How do I calculate the number of days between two dates, excluding

  • Thread starter Thread starter Guest
  • Start date Start date
Datediff function e.g.

DateDiff("d",[DateField1],[DateField2])

So if Date1 = 01/11/2005
and Date2 = 01/21/2005
then the datdiff function above would bring back 10.

I think you can replace the "d" with like an "m" to get the number of months
difference. There is probably some good documentation in MSDN as to other
parameters for the intervals for this function. (i.e."d" or "m" etc)
 
Ignore me I must learn to read the question.

Try this article
http://support.microsoft.com/default.aspx?scid=kb;en-us;95977

Whitless said:
Datediff function e.g.

DateDiff("d",[DateField1],[DateField2])

So if Date1 = 01/11/2005
and Date2 = 01/21/2005
then the datdiff function above would bring back 10.

I think you can replace the "d" with like an "m" to get the number of months
difference. There is probably some good documentation in MSDN as to other
parameters for the intervals for this function. (i.e."d" or "m" etc)

gillt97 said:
How do I calculate the number of days between two dates, excluding weekends.
Click to expand...
Click to expand...
 
Rick,
While I agree with your attempt to help people to learn how to find the
answers for themselves, quite often people who come to these newsgroups
don't know where to search for the answers. You might want to consider, at
the very least, giving them a suggestion of a possible place to start their
search.
 
Back
Top