i want to work out the difference between two dates in days. i tried it a few way but always got the woring answer.

any ideas??

Did you try datediff?

The format would be:

Datediff("d",[OneDate],[OtherDate])

The "d" stands for days. "n" would give the results in minutes.