RE: Finding the amount of days between two dates.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike H <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 2 Apr 2008 08:05:05 -0700

Maybe

datefrom = #4/1/2008#
dateto = #4/4/2008#
diffference = dateto - datefrom + 1

Mike

"NateBuckley" wrote:

Greetings, I'm sure the solution to this, is easier than I think, but for the
life of me I can't figure this out.

I have two variables of data type Date.

DateFrom
DateTo

I'm attempting to get it so I can work out how many days there are between
these two dates.

DateFrom = 01/04/08
DateTo = 04/04/08
The Result should be 4.

I was thinking just grab the Day from the date and that'd be easy, but the
problem arises when you have dates that span a few months in distance.

Thank you for any help thrown in this general direction :) .

Follow-Ups:
- RE: Finding the amount of days between two dates.
  - From: NateBuckley

References:
- Finding the amount of days between two dates.
  - From: NateBuckley

Prev by Date: sumifs
Next by Date: Arrays or sumifs
Previous by thread: Finding the amount of days between two dates.
Next by thread: RE: Finding the amount of days between two dates.
Index(es):
- Date
- Thread

Relevant Pages

Re: Datumsdifferenz o. Samstage u. Sonntage
... Dim i As Long, j As Long ... Public Function countWeekDays(DateFrom As Date, DateTo As Date) As Long ... If DateFrom> DateTo Then ...
(microsoft.public.de.access)
RE: Finding the amount of days between two dates.
... "NateBuckley" wrote: ... "Mike H" wrote: ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
(microsoft.public.excel.programming)
RE: Finding the amount of days between two dates.
... "NateBuckley" wrote: ... life of me I can't figure this out. ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
(microsoft.public.excel.programming)
Re: Interval search
... >> Remi-Noel ... > I'd recommend instead to use DateTo and DateFrom as global fields, ...
(comp.databases.filemaker)
Re: Date format for SQL Server
... > The datefrom and dateto are derived using DateSerial. ... If the parameter is defined as a date (adDate if you're using ADO) and you ...
(microsoft.public.vb.syntax)