Dates

  • Thread starter Thread starter Apollo
  • Start date Start date
A

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.
 
Hi,
How do I truncate or format this to only display the date portion on the
report ?
Click to expand...

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