Thanks Boris
Was having a senior moment, was trying to take a datetime from the date(), doohhh!
>>Hi
>>
>>I want to work out the difference between to datetimes, IE the current datetime - m.sdatetimestarted
>>
>>Any ideas?
>
>Difference between two datetimes are in seconds:
>
>sdatetimestarted = DATETIME(2011,1,31,23,12,00)
>? DATETIME() - sdatetimestarted
>
Rob