PC Review


Reply
Thread Tools Rate Thread

Count the days between 2 dates

 
 
Samuel
Guest
Posts: n/a
 
      13th Jul 2007
Is there a method that I can use in access that counts the days between 2
specified dates?

Thank you,
Samuel


 
Reply With Quote
 
 
 
 
=?Utf-8?B?QW5hbHlzdDcy?=
Guest
Posts: n/a
 
      13th Jul 2007
Have you tried the DateDiff function
http://msdn2.microsoft.com/en-us/library/Aa262712(VS.60).aspx

"Samuel" wrote:

> Is there a method that I can use in access that counts the days between 2
> specified dates?
>
> Thank you,
> Samuel
>
>
>

 
Reply With Quote
 
Allen Browne
Guest
Posts: n/a
 
      13th Jul 2007
Use DateDiff(), e.g.:
DateDiff("d", [Date1], [Date2])

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Samuel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is there a method that I can use in access that counts the days between 2
> specified dates?
>
> Thank you,
> Samuel
>


 
Reply With Quote
 
fredg
Guest
Posts: n/a
 
      13th Jul 2007
On Fri, 13 Jul 2007 15:39:52 +0100, Samuel wrote:

> Is there a method that I can use in access that counts the days between 2
> specified dates?
>
> Thank you,
> Samuel


= [Date1]-[Date2]
or
= DateDiff("d",[Date1],[Date2])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 
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
Count days between text dates Benny Microsoft Excel Misc 8 11th Aug 2009 05:58 PM
Count of days between dates Andy Microsoft Excel Misc 2 15th Apr 2009 10:51 AM
Count Number of days between dates blinton25 Microsoft Access Queries 2 17th Aug 2004 10:33 PM
count # of days from 2 dates Ninkasi Microsoft Access Forms 1 13th Jul 2004 07:51 AM
count days between dates cogent Microsoft Excel Programming 3 7th May 2004 07:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:13 AM.