I would suggest that you store empty dates as Nulls. It'll resolve your problems.
>I am using backend sqlserver tables with datetime fields. I have set the default values for the datetime fields to be blank using (''), not to NULL. (I am not sure this was the best decision?)
>
>SQL Server stores 'blank' dates as 01/01/1900 plus the time portion.
>I have a read only grid that displays these dates. How can I show them as empty? I guess I could change my remote view to have an additional field for the date that uses an expression to convert it to a blank string - although I don't know transact-sql that well, compared to vfp, to know what that expression would be.
>
>Ideally I would like to be able to have some kind of function or property of the text box in the grid that allows me to reformat it. Something like:
>
>a property of 'displaystring'
>with a value of =mycustomstringformat()
>and the mycustomstringformat function manipulates the string and returns it for display.
>
>I am wondering if I can replace the text object in the grid with a label, and manipulate the value property of the label?
>
>Any suggestions would be appreciated
>
>TIA
--sb--