Hi All ---
Ran into an interesting problem (I should have known better but that's another story)....if you attempt to post blank dates via a remote view to SQL Server, you get 01/01/1900 as the return date value. Not so nice, eh?
The trick is to set the column in SQL Server to allow Nulls and then post a null instead of a blank...of course, you also have to be prepared to accept nulls for databound controls.
Thought I would share this.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05