Date Calculation in a query

[Guest]

I have three fields one call Admin Review Date, Amount of days, and the
other next admin review. Some are schedule to have the next admin review in
30,60 or 90 days. I need a formula that would calculate the next admin review
automatically. For example

If Mr Lee had an Review on 10/30/2005 and he was given 30 days to have the
next admin review i want this field to tell me that his next admin review
date iis on 11/30/2005

How can i do this.

 

[Guest]

Try and use the DateAdd Function

Select [Admin Review Date], [Amount of days], DateAdd("d",[Amount of
days],[Admin Review Date]) As [next admin review] From TableName

 

[Joe Cilinceon]

I have three fields one call Admin Review Date, Amount of days, and
the other next admin review. Some are schedule to have the next admin
review in 30,60 or 90 days. I need a formula that would calculate the
next admin review automatically. For example

If Mr Lee had an Review on 10/30/2005 and he was given 30 days to
have the next admin review i want this field to tell me that his next
admin review date iis on 11/30/2005

How can i do this.

DateAdd("d",30, #10/30/2005#) Oh and it would return 11/29/2005 not the
30th.

 

[Guest]

Where do i put this. I have a query is it
Nextadmingreviewdate=[adming review date],[amount of days], date
add("d",[amount of days], [admin review date] as [next admin review]

Try and use the DateAdd Function

Select [Admin Review Date], [Amount of days], DateAdd("d",[Amount of
days],[Admin Review Date]) As [next admin review] From TableName
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

I have three fields one call Admin Review Date, Amount of days, and the
other next admin review. Some are schedule to have the next admin review in
30,60 or 90 days. I need a formula that would calculate the next admin review
automatically. For example

If Mr Lee had an Review on 10/30/2005 and he was given 30 days to have the
next admin review i want this field to tell me that his next admin review
date iis on 11/30/2005

How can i do this.

 

[Guest]

Yes, you should use that in a query.
If you want me to help you building this query, then create a simple select
query listing the fields of the table and post the SQL of the query.

Select Field1,Field2,Field3 From TableName
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Where do i put this. I have a query is it
Nextadmingreviewdate=[adming review date],[amount of days], date
add("d",[amount of days], [admin review date] as [next admin review]

Try and use the DateAdd Function

Select [Admin Review Date], [Amount of days], DateAdd("d",[Amount of
days],[Admin Review Date]) As [next admin review] From TableName
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

I have three fields one call Admin Review Date, Amount of days, and the
other next admin review. Some are schedule to have the next admin review in
30,60 or 90 days. I need a formula that would calculate the next admin review
automatically. For example

If Mr Lee had an Review on 10/30/2005 and he was given 30 days to have the
next admin review i want this field to tell me that his next admin review
date iis on 11/30/2005

How can i do this.

 

[Joe Cilinceon]

Add a to an empty field to your query the following line.... NextReview:
DateAdd("d", [Amount of Days], [Admin Review Date])

 

[Guest]

Can you tell how to do this more clearly. I'm not understanding

Yes, you should use that in a query.
If you want me to help you building this query, then create a simple select
query listing the fields of the table and post the SQL of the query.

Select Field1,Field2,Field3 From TableName
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Where do i put this. I have a query is it
Nextadmingreviewdate=[adming review date],[amount of days], date
add("d",[amount of days], [admin review date] as [next admin review]

Try and use the DateAdd Function

Select [Admin Review Date], [Amount of days], DateAdd("d",[Amount of
days],[Admin Review Date]) As [next admin review] From TableName
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

I have three fields one call Admin Review Date, Amount of days, and the
other next admin review. Some are schedule to have the next admin review in
30,60 or 90 days. I need a formula that would calculate the next admin review
automatically. For example

If Mr Lee had an Review on 10/30/2005 and he was given 30 days to have the
next admin review i want this field to tell me that his next admin review
date iis on 11/30/2005

How can i do this.

 

[Guest]

Can you post the names of the
1. Table
2. Admin Review Date field in the table
3. Amount of days field in the table
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

Try and use the DateAdd Function

Select [Admin Review Date], [Amount of days], DateAdd("d",[Amount of
days],[Admin Review Date]) As [next admin review] From TableName
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

I have three fields one call Admin Review Date, Amount of days, and the
other next admin review. Some are schedule to have the next admin review in
30,60 or 90 days. I need a formula that would calculate the next admin review
automatically. For example

If Mr Lee had an Review on 10/30/2005 and he was given 30 days to have the
next admin review i want this field to tell me that his next admin review
date iis on 11/30/2005

How can i do this.

 

[Guest]

If i type NextReview: DateAdd("d", [Amount of Days], [Admin Review Date])
I get and the following error message #error, on the one's that don't have
number of days.

Add a to an empty field to your query the following line.... NextReview:
DateAdd("d", [Amount of Days], [Admin Review Date])

DateAdd("d",30, #10/30/2005#) Oh and it would return 11/29/2005 not
the 30th.