Prev: Application crashes at start-up
Next: Attaching to a DLL
From: Apollo on 1 Apr 2010 16:40
Hi All ...
I'm a newbeee using vb2008 express, vs2008, & sql 2008 express.

I have created a column in my sql table with the DATE data type as I only
want to store/display the date portion in my winform control field which
works fine on a but on a report I also get the default time (12:00:00 AM)
displayed.

How do I truncate or format this to only display the date portion on the
report ?

Thanks
Paul J.

From: Patrice on 1 Apr 2010 17:48
Hi,

> How do I truncate or format this to only display the date portion on the
> report ?

The report is done using ? Programmatically you would call
MyDate.ToString("d") to show the date without the time portion. Your
reporting tool (Crystal, SSRS ?) should have a Format property in which you
could enter the same "d" format string and it should have the same effect...

--
Patrice

 | 
Pages: 1
Prev: Application crashes at start-up
Next: Attaching to a DLL