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
  2. Madhivanan Moderator

    Try
    Format("col","dd/mm/yyyy")
  3. mastersql New Member

    Where I have to put this formula
  4. dineshasanka Moderator

    you can include this at expression of the text box.
    Right click the filed and select expression
  5. mastersql New Member

    This is not working, it showing dd/mm/yyyy but not showing date
  6. dineshasanka Moderator

    can you paste tour fomula please
  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

Share This Page