Auto Calculate days w/start date & End date

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I have a form that I would like to calculate how many days are in-between a
start date and an end date. If this is possible any help would be greatly
appreciated. Thank you
 
=DateDiff("d",[StartDate],[EndDate])

This is how the expression would appear in the Control Source of an unbound
text box. In a query:

CalcDays: DateDiff("d",[StartDate],[EndDate])

Use a name of your choosing in place of CalcDays.
 
Awsome thank you

BruceM said:
=DateDiff("d",[StartDate],[EndDate])

This is how the expression would appear in the Control Source of an unbound
text box. In a query:

CalcDays: DateDiff("d",[StartDate],[EndDate])

Use a name of your choosing in place of CalcDays.

Ben said:
I have a form that I would like to calculate how many days are in-between a
start date and an end date. If this is possible any help would be greatly
appreciated. Thank you
Click to expand...
Click to expand...
 
Back
Top