Date Format

Inclusive or exclusive?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Bob Barrows [MVP]" wrote in message
...
And how many days are actually between these two dates ... ?
Fewer than 104 I would imagine ... :-)

Jeff Boyce wrote:
Jim

I'm not understanding your problem...

When I subtract 313 from 417, I get 104.


"Jim" wrote in message
...
I am working with a government database that has a number field that
contains date information formatted to read 20080623. I am trying to
get the difference between two dates, but it's showing the
difference between 20080313 and 20080417 as 104 days. I've tried a
number of fixes shown for others, but I keep getting a message that
the fix is too complicated. Any ideas on how to fix this so that a
beginner can figure it out?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Seriously? How many days are there between March 13 and April 17?
More like 36, isn't it?
Or are you arguing that those numbers might not represent those dates ... ?

Jeff Boyce wrote:
Inclusive or exclusive?


"Bob Barrows [MVP]" wrote in message
...
And how many days are actually between these two dates ... ?
Fewer than 104 I would imagine ... :-)

Jeff Boyce wrote:
Jim

I'm not understanding your problem...

When I subtract 313 from 417, I get 104.


"Jim" wrote in message
...
I am working with a government database that has a number field
that contains date information formatted to read 20080623. I am
trying to get the difference between two dates, but it's showing
the difference between 20080313 and 20080417 as 104 days. I've
tried a number of fixes shown for others, but I keep getting a
message that the fix is too complicated. Any ideas on how to fix
this so that a beginner can figure it out?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

If the difference is showing as described, the OP isn't doing "date" math.

Let's check back with the OP to see if the field is a Date/Time field, or if
the numbers are just numbers...

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Bob Barrows [MVP]" wrote in message
...
Seriously? How many days are there between March 13 and April 17?
More like 36, isn't it?
Or are you arguing that those numbers might not represent those dates ...
?

Jeff Boyce wrote:
Inclusive or exclusive?


"Bob Barrows [MVP]" wrote in message
...
And how many days are actually between these two dates ... ?
Fewer than 104 I would imagine ... :-)

Jeff Boyce wrote:
Jim

I'm not understanding your problem...

When I subtract 313 from 417, I get 104.


"Jim" wrote in message
...
I am working with a government database that has a number field
that contains date information formatted to read 20080623. I am
trying to get the difference between two dates, but it's showing
the difference between 20080313 and 20080417 as 104 days. I've
tried a number of fixes shown for others, but I keep getting a
message that the fix is too complicated. Any ideas on how to fix
this so that a beginner can figure it out?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Jeff Boyce wrote:
If the difference is showing as described, the OP isn't doing "date"
math.

Exactly! He WANTS to do date math,

"I'm trying to get the difference between two dates, but ..."

but he could not figure out how to convert his numbers to proper dates so he
could do date arithmetic with them..

Let's check back with the OP to see if the field is a Date/Time
field, or if the numbers are just numbers...

No need. He told us exactly what the data type was:

" ... database has a number field that contains date information formatted
to read 20080623"

Come on, Jeff: time to let this go. Everyone else in the thread understood
the problem.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Forest for the trees ...

Thanks, Bob!

Jeff

"Bob Barrows [MVP]" wrote in message
...
Jeff Boyce wrote:
If the difference is showing as described, the OP isn't doing "date"
math.

Exactly! He WANTS to do date math,

"I'm trying to get the difference between two dates, but ..."

but he could not figure out how to convert his numbers to proper dates so
he
could do date arithmetic with them..

Let's check back with the OP to see if the field is a Date/Time
field, or if the numbers are just numbers...

No need. He told us exactly what the data type was:

" ... database has a number field that contains date information
formatted
to read 20080623"

Come on, Jeff: time to let this go. Everyone else in the thread understood
the problem.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"