Hi.
I am running xMII version 11.5, patch 3 and have a problem. If I try and run the following datefromseconds(0) it returns "0001-01-01T06:00:00". I would have expected "0000-00-00T00:00:00" or at least "0001-01-01T00:00:00"
A workaround could be ....
datefromseconds(
datetoseconds("0001-01-01T00:00:00") +
datediff("2007-09-12T09:44:53","2007-09-12T10:44:53"))
If I want a daterepresentation of the the timedifference...
BR.
Poul.