RE: Finding the amount of days between two dates.
- From: NateBuckley <NateBuckley@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 2 Apr 2008 08:26:03 -0700
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 :) .
- Follow-Ups:
- RE: Finding the amount of days between two dates.
- From: Mike H
- RE: Finding the amount of days between two dates.
- References:
- Finding the amount of days between two dates.
- From: NateBuckley
- RE: Finding the amount of days between two dates.
- From: Mike H
- Finding the amount of days between two dates.
- Prev by Date: Merging excel info into a word table
- Next by Date: spellcheck a textbox on a protected work***
- Previous by thread: RE: Finding the amount of days between two dates.
- Next by thread: RE: Finding the amount of days between two dates.
- Index(es):