General information
Category:
Forms & Form designer
Title:
Can I display sqlserver date 1/1/1900 as empty?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only