RE: Finding the amount of days between two dates.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It's part of the syntax for formatting a user date in VB

"NateBuckley" wrote:

What does the hash character mean?

And That worked great cheers :)

"Mike H" wrote:

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 :) .
.

Relevant Pages

  • 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: 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: The original version
    ... One of the fundamental principles of Anchor Modeling is that it is ... based on DateFrom for the new attribute’s value. ... There is no DateTo. ... Regarding history of databases this is logical nonsense. ...
    (comp.databases.theory)
  • Re: Interval search
    ... >> Remi-Noel ... > I'd recommend instead to use DateTo and DateFrom as global fields, ...
    (comp.databases.filemaker)