Solved

Yesterday's Date

Posted on 2011-09-20
6
3,134 Views
Last Modified: 2012-05-12
Hi,
I am using an expression to show today's date but would like to show yesterday's date instead.  I am using a Report Builder 3.0 (SSRS) and trying to create a prameter to create an expression.  Here is what i have now to show today's date :
=Now()
but would like to show yesterday's date.  thanks
0
Comment
Question by:karinos57
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 36567409
please try:

now()-1
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36567453
Try this...

=DateAdd("d",-1,Now())
0
 

Author Comment

by:karinos57
ID: 36567882
edlunad,
this is works only when i delete the time from the date box. In the date box it shows like this:
09/19/2011 11:39:68 AM

so if i only delete the time in here then it will work.  thanks
see attached.
Doc1.docx
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 9

Accepted Solution

by:
edlunad earned 250 total points
ID: 36568562
If you only want to display the Date and not the time, you should calculate the value using Today() not Now()

=DateAdd("d",-1,Today())
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36568578
If still that doesnt bring you just the Date, you can format it like this...

=FormatDateTime(DateAdd("d",-1,Today()),DateFormat.ShortDate)
0
 

Author Closing Comment

by:karinos57
ID: 36568618
thanks
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question