>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
>>
You can do that either ;-)
sdatetimestarted = DTOT(DATE())
?DATETIME - sdatetimestarted
Best Regards
-Tom
Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.
Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011