Calculating days from two different dates

  • Thread starter Thread starter Fly Boy 5
  • Start date Start date
F

Fly Boy 5

Expr1: IIf([Taken],[Date_To]-[Date_Fm]+1,0) This displays the days taken but
it would be nice to display days scheduled.

Date fields called Date_To and another Date_Fm for vacations. How can I
display days scheduled?

Thanks for your help!
 
How can I display days scheduled?
You just gotta have fields to indicate the schedule - StartDate, NumOfDays.
 
Expr1: IIf([Taken],[Date_To]-[Date_Fm]+1,0) This displays the days taken but
it would be nice to display days scheduled.

Date fields called Date_To and another Date_Fm for vacations. How can I
display days scheduled?

Thanks for your help!
Click to expand...

DateDiff("d", [Date_Fm], [Date_To])

will calculate the number of calendar days between the two dates. If you need
*business* days, excluding weekends and holidays, see

http://www.mvps.org/access/datetime/date0012.htm

or

http://www.accessmvp.com/djsteele/Diff2Dates.html
 
Back
Top