How to display yesterdays date in SSRS expression

Question

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 ?

Blockbusting

Answer 1

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

Sidero

IS there any way ,i can make Month name Caps in the above expression? – Blockbusting

use UCase function .. =UCase(format(dateadd("d", -1, today()), "MMMM,dd,yyyy")) – Sidero

Answer 2

If you want add dynamic date or yesterday date in email body using ssrs tool SQL Server 2017, please fellow these steps:

Step 1>

Upload rdl file .

Step 2> Right click on file

Then click manage

Step 3> In Left menu click Subscription

Step 4> Click New Subscription

You will see this window

Then choose data-driven subscription

Then click edit dataset

Then you will get below window

From this select custom source you will get below window

after filling all type query like you want yesterday date then type below query:

Then click Validate Query AND APPLY

IN SUBJECT TAKE VALUE FROM DATABASE AND SEND MAIL

Heyday