>When I have a view which reads a date field with no value in it, the view uses a default date with 1899 or something like that. Is this considered standard behaviour? Is there an easy way to sidestep this?
>
>Thanks,
>
>Peter
When sending empty dates to SQL Server, you will be returned some date in 1899. You need to send it a .null. date.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown