>Hi Michel,
>
>SECONDS() only returns the number of seconds passed since midnight.
>
>Using DATETIME() should solve this problem.
>
>
>dtStartTime = {04/07/2001 11:59:59 PM}
>dtEndTime = {05/07/2001 12:00:01 AM}
>nTotalSeconds = dtEndTime - dtStartTime
>
>
>The above example will return 2 seconds.
>
>Please note that I'm using a BRITISH date format.
Yes, I thought about that after I sent this message. Thanks <s>