SQL Server Performance

Date Format

Discussion in 'SQL Server 2005 Reporting Services' started by mastersql, Sep 23, 2007.

  1. mastersql New Member

    I am creating a report in Business Intelligence Studio
    there I am getting a problem is that, I have a one date column in format smalldatetime, in my SQL Server Table
    I want to show it in my report in different format which is dd/mm/yyyy.
    What I have to do for this
    Ashish Kukreja
    mastersql, Sep 23, 2007
    #2

  2. Madhivanan Moderator

    Try
    Format("col","dd/mm/yyyy")
    Madhivanan, Sep 24, 2007
    #3

  3. mastersql New Member

    Where I have to put this formula
    mastersql, Sep 24, 2007
    #4

  4. dineshasanka Moderator

    you can include this at expression of the text box.
    Right click the filed and select expression
    dineshasanka, Sep 24, 2007
    #5

  5. mastersql New Member

    This is not working, it showing dd/mm/yyyy but not showing date
    mastersql, Sep 24, 2007
    #6

  6. dineshasanka Moderator

    can you paste tour fomula please
    dineshasanka, Sep 24, 2007
    #7

  7. mastersql New Member

    I can't get you
    I try that formula in Expression
    =Format("Fields!Next_Visit_Date.Value","dd/mm/yyyy")
    next_visit_date is my coloumn name
    mastersql, Sep 25, 2007
    #8

Share This Page