I would be very thankful if anybody could help me with this:
If there is a date field with a null value it defaults to 1.1.1900
is it possible to change the default to the empty datevalue or ' / / '
Thanks
Bjarni SigurdssonIf the value is indeed NULL, you can detect that by binding an indicator
field for the row/parameter in question.
"gandalf" <anonymous@.discussions.microsoft.com> wrote in message
news:08ed01c4b1ca$4e9c6900$a401280a@.phx.gbl...[vbcol=seagreen]
> a date is internally stored as a number
> You could use a CASE-statement to show another value
>
> this:
> 1.1.1900
> datevalue or ' / / '
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment