I thought EMPTY(ALLTRIM(mytable.mydatetime)) would work to check for an empty datetime field, but I guess I have to convert it first???

It doesn't seem to work as above.

Thanks for your assistance.