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 ?

Tak · Accepted Answer · 2014-09-08T13:51:33.513

13

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

edited Sep 08 '14 at 13:51

answered Sep 05 '14 at 17:10

Tak

1

IS there any way ,i can make Month name Caps in the above expression? – SqlLearner Sep 08 '14 at 17:18
1

use UCase function .. `=UCase(format(dateadd("d", -1, today()), "MMMM,dd,yyyy"))` – Tak Sep 08 '14 at 17:23

score 1 · Answer 2 · edited Dec 21 '18 at 17:49

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

2 Answers2