Number of Seconds between dates

[rhoneyfi]

I have a 2 date/time fields and would like to determine the # of seconds between the dates.

ex: dates are "12/1/02 16:00:00" and "12/3/03 18:00:00". The formula should give me 180,000 seconds as the difference between the two.

Thanks

 

[rhoneyfi]

O00pps, the dates listed above should both be in the year 2002....not 2002 and 2003....sorry for the confusion

 

[synapsevampire]

Use:

datediff("s",{Orders.Order Date},{Orders.Ship Date})

-k