If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating dates based on two dates from 24 hours
I have two dates in my database. I need to start to write and track a
report from the second date 24 hours after the first date. I need to report on the time frame it takes to return packets. They are supposed to be returned in a 24 hour period. |
#2
|
|||
|
|||
Calculating dates based on two dates from 24 hours
Hi
There is a really good funtion here (just tried them both and I personally like the 2nd one as it gives a clearer result) http://office2010.microsoft.com/en-g...in=EC001022701 just use dateadd to add 1 day to your first time/date and then call the funtion in a query - you can then use the resorts in a form or report HTH -- Wayne Manchester, England. "Alaska1" wrote: I have two dates in my database. I need to start to write and track a report from the second date 24 hours after the first date. I need to report on the time frame it takes to return packets. They are supposed to be returned in a 24 hour period. |
Thread Tools | |
Display Modes | |
|
|