>Is there a way to subtract one datetime field from another to find the amount of time between them? I asked this question a few weeks ago but my proble then was solvable using seconds(). This time it isn't.
When you substruct one datatime field from another you get difference in seconds.
For example dd1 = {01/01/97 12:00 am}
dd2 = {01/01/97 12:15 am}
dd2-dd1 will be 900 (900 seconds in 15 minutes)

ALEX