Date Differences

[essaysmith]

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

 

[pdx_man]

Check out the DateDiff function under the online Help. That should do it.

 

[essaysmith]

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.

 

[joeyreyma]

not tested but try this:

Difference = DateDiff("d",Current_FieldDate, DMin("FieldDate","Table","FieldDate >#" & Current_FieldDate & "#")

 

[essaysmith]

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).

 

[fmcampos]

I'm having the same problem...couldn't find any command that would select the previous record..

 

[Rich]

Look up the PrevRecVal function.

 

[David R]

Here's the article that explains PrevRecVal (Which I keep trying to type as FindPrevCal for some reason): http://support.microsoft.com/default.aspx?scid=kb;en-us;Q101081
It also has some lower-intensity solutions using Dlookup, if your database is amicable to them.

Good luck,
David R