>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.
Yes, I have had a lot of 'FUN' with this 'feature' in SQL Server. Sometimes I am lazy and just do an IIF in a report so the user doesn't see that date.
DLC