How to display yesterdays date in SSRS expression

reporting-services ssrs-2008 ssrs-grouping ssrs-expression
SqlLearner picture SqlLearner · Sep 5, 2014 · Viewed 30.4k times · Source

In one of the column name, I need to display yesterday's date like - September 4,2014

I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM.

How can i get the above format like - monthname,dd,YYYY ?

Answer

Tak picture Tak · Sep 5, 2014

Use .. =format(dateadd("d", -1, today()), "MMMM dd,yyyy")

Related questions

How to sum the Group totals only?

I'm trying to sum only group HourTarget totals. 7:00 8:00 HourTarget Line 1 2715 1008 3224 A 2307 1008 3224 B 408 0 3224 Line 2 2308 2432 2656 A 2308 2432 2656 Line 3 2318 1622 2800 A 345 1258 2800 B 762 0 2800 C 1211 364 2800 I'm trying to achieve 8680 as a result of sum of HourTarget. But I'm getting 17504. It is because HourTarget in a database table …

Read More
How to create a report with sections and page breaks using SSRS

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), subject varchar(30), currentGrade varchar(2), targetGrade varchar(2), note1 varchar(100), …

Read More
Is it possible to create a row that spans all columns of a Matrix in SSRS 2008?

Is it possible to have add a row to an SSRS 2008 Matrix that spans all of the matrix's columns? This crude diagram shows roughly what I'm looking for: The basic idea is that each line item is a person, and …

Read More