reporting-servicesssrs-2008ssrs-groupingssrs-expression

How to display yesterdays date in SSRS expression

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 ?

Solution

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