Mark

"...To me, 1900-01-01 is not acceptable so I wrote my own"

Why not use a default value to populate the datetime() field?

"...They make some assumptions about the underlying tables, particularly the primary key (but it could be modified relatively easy)"

My code has to be dynamic as it's used on 100's of tables, and it's called from various other platforms too.

Regards

Derek