Search code examples
sqlsql-serverreporting-servicesssrs-2008ssrs-2008-r2

How to Display only the Datepart using Expression in SSRS?

I need to display only the Datepart(6/26/2000) in the report by neglecting Time in the Report in SSRS. already i'm fetching the that datetime from the Dataset output column Startdate

Expression Used:

=First(Fields!start_dte_display.Value, "Salesvalue")

SalesValue==>Dataset name

Output i'm getting from above Expression :

6/26/2000 12:00:00 AM

My expected Output:

6/26/2000

Kindly Help me with the output!!

Solution

  • Try FORMAT:

    =Format(First(Fields!start_dte_display.Value, "Salesvalue"), "MM/dd/yyyy")

    Note: MM has to be in upper-case, mm will get you minutes!