Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement