Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2012-04-24 : 03:40:50
|
| Hello all,in a cell of my RS2003 I show a DateTime value like this:2012-01-01 00:15:00.000Is it possible to exclude the second? So I obtain:2012-01-01 00:15Thanks in advance. Luigi |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-04-24 : 11:01:41
|
| Set the FORMAT to "yyyy-M-dd HH:mm"You could also set the expression in the cell to the formatted value: =Format(Fields!DateCol.Value,"yyyy-M-dd HH:mm") |
 |
|
|
|
|
|
DateTime field without seconds