This is easy in FoxPro, of course, so I'm thinking it must be just as easy in MS-SQL, and that I only need to find out the right syntax.
I've created a DateTime field, and I want it to automatically populate with the current system date & time when a record is added.
Trouble is, whenever I try to enter anything—anything at all—into the Default Value field in Table Designer, I get an error: "Error validating the default for column 'tPaymentReceivedDate'."
What's an overworked genius to do?
TIA,
Jeff