Auto Calculate days w/start date & End date

's Computer Specifications

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

's Computer Specifications

=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" <(E-Mail Removed)> wrote in message
news:EB2AC7E6-200D-4377-B7CB-(E-Mail Removed)...
>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

's Computer Specifications

Awsome thank you

"BruceM" wrote:

> =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" <(E-Mail Removed)> wrote in message
> news:EB2AC7E6-200D-4377-B7CB-(E-Mail Removed)...
> >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
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate 60 days from Start Date - including weekends	Missy	Microsoft Excel Worksheet Functions	5	19th Aug 2009 04:27 PM
How do I auto calculate 90 days days from a certain date?	=?Utf-8?B?VCBDdW1taW5ncw==?=	Microsoft Outlook	4	2nd Sep 2008 03:01 PM
Auto calculate for date + days forward to yield new date	=?Utf-8?B?Sm9obiBTdWxsaXZhbg==?=	Microsoft Excel Worksheet Functions	1	22nd Apr 2006 05:18 PM
calculate number of days from start date to date completed?	=?Utf-8?B?TGluZGE=?=	Microsoft Outlook Discussion	2	24th Feb 2006 08:09 PM
Calculate number of days between a start date and an end date	=?Utf-8?B?ZnJhbmtsaW5idWtvc2tp?=	Microsoft Access	2	24th Jul 2005 05:46 PM