how do i create a date queries

[Guest]

What type of querie do i need to create in order to find out how long a case
has been open.

 

[Rick B]

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.

 

[Guest]

Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B

What type of querie do i need to create in order to find out how long a case
has been open.

 

[Rick B]

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B

Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B

What type of querie do i need to create in order to find out how long

a
case

has been open.

 

[Guest]

But it gives me number of days the case has been open i need months

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B

Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B



What type of querie do i need to create in order to find out how long a
case
has been open.

 

[Guest]

I need number of months the case has been open not days. If i put in the
formula it gives me days

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B

Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B



What type of querie do i need to create in order to find out how long a
case
has been open.

 

[Rick B]

You did not say you needed months.

What exactly do you want?

If the case was openind on June 29 and today is July 1, what do you want to
see?

What if the case was opened on June 1 and today is June 30?

Explain how you calculate a "month" in this case.

There are several ways to do this.

--
Rick B

But it gives me number of days the case has been open i need months

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B

Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B



What type of querie do i need to create in order to find out how

long
a

case
has been open.

 

[Rick B]

One method is to use DATEDIFF...

I a qery, you'd add a new field (column) with the following in it...

AgeOfContract: DateDiff("m",[dateOpened],Date())



If you are doing this in a form or report, use an unbound text box and put
the following in it.

=DateDiff("m",[dateOpened],Date())


If this does not calculate the way you think it should, then you may need to
do some additional things such as pulling the first day of the month for
each entry or pulling out the "month" and subtracting.


--
Rick B

But it gives me number of days the case has been open i need months

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B

Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B



What type of querie do i need to create in order to find out how

long
a

case
has been open.

 

[Guest]

For example if a case was open in 12/10/2003. From that date to today is 559
days, which is what the formula you gave me gives me. I want it to tell me
how many months the case has been open? Not how many days

You did not say you needed months.

What exactly do you want?

If the case was openind on June 29 and today is July 1, what do you want to
see?

What if the case was opened on June 1 and today is June 30?

Explain how you calculate a "month" in this case.

There are several ways to do this.

--
Rick B

But it gives me number of days the case has been open i need months

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B



Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B



What type of querie do i need to create in order to find out how long
a
case
has been open.

 

[Guest]

For example case LALALA was open on 12/10/2003 from todays date the case has
been open this amount of months.

That's what i need

You did not say you needed months.

What exactly do you want?

If the case was openind on June 29 and today is July 1, what do you want to
see?

What if the case was opened on June 1 and today is June 30?

Explain how you calculate a "month" in this case.

There are several ways to do this.

--
Rick B

But it gives me number of days the case has been open i need months

Date() uses the current system date. So, your answer today will be one less
than it will be tomorrow.

--
Rick B



Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column to a
query.


--
Rick B



What type of querie do i need to create in order to find out how long
a
case
has been open.

 

[Rick B]

Again, what answer would you expect here?

Is this 18 month? 16 months?

TELL ME HOW YOU CALCULATE THIS MANUALLY AND I WILL TELL YOU HOW TO DO IT IN
ACCESS!!!!!!

Give me a specific example!!

I asked you specifically,

If it was opened on June 19 and today is July 1, WHAT ANSWER WOULD YOU
EXPECT? Is that two months? One? None?

PLEASE GIVE ME SPECIFIC EXAMPLE AND ANSWER USING YOUR CURRENT METHOD OF
CALCULATION.

You need to be SPECIFIC when you post here. I posted several responses
before you even bothered to state you wanted months. I then asked you how
you calculate a "month" and you never gave me a specific.

C'mon now!


--
Rick B

For example case LALALA was open on 12/10/2003 from todays date the case has
been open this amount of months.

That's what i need

You did not say you needed months.

What exactly do you want?

If the case was openind on June 29 and today is July 1, what do you want to
see?

What if the case was opened on June 1 and today is June 30?

Explain how you calculate a "month" in this case.

There are several ways to do this.

--
Rick B

But it gives me number of days the case has been open i need months

:

Date() uses the current system date. So, your answer today will be

one
less

than it will be tomorrow.

--
Rick B



Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new

column
to a

query.


--
Rick B



What type of querie do i need to create in order to find out

how
long

a
case
has been open.

 

[Guest]

I expect to get 18 months and 11 days. Which i did get the 18 months with the
formula you send me before.

I count from 12/10/2003 to 12/10/2004 is one year which is 12 month and 6
month from January 2005 to June 2005 = 18 months

Again, what answer would you expect here?

Is this 18 month? 16 months?

TELL ME HOW YOU CALCULATE THIS MANUALLY AND I WILL TELL YOU HOW TO DO IT IN
ACCESS!!!!!!

Give me a specific example!!

I asked you specifically,

If it was opened on June 19 and today is July 1, WHAT ANSWER WOULD YOU
EXPECT? Is that two months? One? None?

PLEASE GIVE ME SPECIFIC EXAMPLE AND ANSWER USING YOUR CURRENT METHOD OF
CALCULATION.

You need to be SPECIFIC when you post here. I posted several responses
before you even bothered to state you wanted months. I then asked you how
you calculate a "month" and you never gave me a specific.

C'mon now!


--
Rick B

For example case LALALA was open on 12/10/2003 from todays date the case has
been open this amount of months.

That's what i need

You did not say you needed months.

What exactly do you want?

If the case was openind on June 29 and today is July 1, what do you want to
see?

What if the case was opened on June 1 and today is June 30?

Explain how you calculate a "month" in this case.

There are several ways to do this.

--
Rick B



But it gives me number of days the case has been open i need months

:

Date() uses the current system date. So, your answer today will be one
less
than it will be tomorrow.

--
Rick B



Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column
to a
query.


--
Rick B



What type of querie do i need to create in order to find out how
long
a
case
has been open.

 

[Rick B]

Then it sounds like you have it!

--
Rick B

I expect to get 18 months and 11 days. Which i did get the 18 months with the
formula you send me before.

I count from 12/10/2003 to 12/10/2004 is one year which is 12 month and 6
month from January 2005 to June 2005 = 18 months

Again, what answer would you expect here?

Is this 18 month? 16 months?

TELL ME HOW YOU CALCULATE THIS MANUALLY AND I WILL TELL YOU HOW TO DO IT IN
ACCESS!!!!!!

Give me a specific example!!

I asked you specifically,

If it was opened on June 19 and today is July 1, WHAT ANSWER WOULD YOU
EXPECT? Is that two months? One? None?

PLEASE GIVE ME SPECIFIC EXAMPLE AND ANSWER USING YOUR CURRENT METHOD OF
CALCULATION.

You need to be SPECIFIC when you post here. I posted several responses
before you even bothered to state you wanted months. I then asked you how
you calculate a "month" and you never gave me a specific.

C'mon now!


--
Rick B

For example case LALALA was open on 12/10/2003 from todays date the

case
has

been open this amount of months.

That's what i need

:

You did not say you needed months.

What exactly do you want?

If the case was openind on June 29 and today is July 1, what do you

want
to

see?

What if the case was opened on June 1 and today is June 30?

Explain how you calculate a "month" in this case.

There are several ways to do this.

--
Rick B



But it gives me number of days the case has been open i need months

:

Date() uses the current system date. So, your answer today will

be
one

less
than it will be tomorrow.

--
Rick B



Will the current date change automatically
for example (06/21/2005)-[dateOpened] is this how it is

:

You just need a caluculated field....

Date() - [DateOpened]


You can put this in a report, in a form, or add it as a new column
to a
query.


--
Rick B



What type of querie do i need to create in order to find

out
how

long
a
case
has been open.