PC Review


Reply
Thread Tools Rate Thread

Auto Calculate days w/start date & End date

 
 
Ben
Guest
Posts: n/a
 
      24th Apr 2009
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
 
Reply With Quote
 
 
 
 
BruceM
Guest
Posts: n/a
 
      24th Apr 2009
=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



 
Reply With Quote
 
Ben
Guest
Posts: n/a
 
      24th Apr 2009
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

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:00 PM.