Date Differences

essaysmith

New member
Local time
Today, 22:19
Joined
Jul 11, 2001
Messages
6
Hi, new guy here. I have a table with a date field and I need to have a field (presumably calculated) that lists the amount of time since the last record. I had thought of bringing the date from the previous record into the next record and subtracting the two, but I cannot figure out how to do it.

Any help would be appreciated, thanks

Shawn
 
Check out the DateDiff function under the online Help. That should do it.
 
Sorry to be a pain, but does that include finding mean time between records and not just from today, for instance:

1 01/01/01
2 01/03/01 Time between: 2 days
3 02/02/02 Time between: 30 days
etc.
 
not tested but try this:

Difference = DateDiff("d",Current_FieldDate, DMin("FieldDate","Table","FieldDate >#" & Current_FieldDate & "#")
 
Thanks, but I only have the current date, or is there a way to pull the previous record value for date into the current record for comparison? Or am I missing something (wouldn't surprise me).
 
I'm having the same problem...couldn't find any command that would select the previous record..
 

Users who are viewing this thread

Back
Top Bottom