RE: Finding the amount of days between two dates.

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: Interval search
    ... >> Remi-Noel ... > I'd recommend instead to use DateTo and DateFrom as global fields, ...
    (comp.databases.filemaker)
  • RE: Finding the amount of days between two dates.
    ... life of me I can't figure this out. ... I have two variables of data type Date. ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
    (microsoft.public.excel.programming)
  • 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)
Quantcast