Dates

[Apollo]

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.

 

[Patrice]

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...