Post reply

Display DATATIME as 10 Char format (2006-10-26)

  • October 25, 2006 at 12:41 pm

    #192884

    RS 101 question.. Editing a .RDL file in Reporting Services 'Layout' designer.  HOW can I get a DATETIME column to display as a 10 character date on the report -- supressing the HHMMSS altogether?   (eg. 2006-10-26) ...  I'm using Vis. Studio 2005  w/ RS 2005

    thx in advance

    BT

  • October 25, 2006 at 1:08 pm

    #667984

    In Visual Studio LAYOUT mode, click the field you want to edit.  Viewing the PROPERITES pane, in APPEARANCE, look for the FORMAT setting.  Type a 'd' into the setting.

    BT

  • October 26, 2006 at 9:39 am

    #668244

    Or you can create a custom format using yy or yyyy for year; M, MM, MMM, or MMMM for month; and d or dd for day. Note, that M's should be capital. For example, to show 2006-10-26 the format string is yyyy-MM-dd

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply