Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Format Date Expression in SSRS

Posted on 2008-10-23
4
Medium Priority
?
1,439 Views
Last Modified: 2012-06-27
I need to be able to create an expression that takes today's date =FormatDateTime(Today()) and format it like 23-OCT-08 minus 1

So the value would actually be 22-OCT-08
0
Comment
Question by:chrisryhal
[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
  • 2
  • 2
4 Comments
 
LVL 12

Expert Comment

by:jgv
ID: 22787169
This should do it
=Format(Date.Today.AddDays(-1), "dd-MMM-yy")
0
 
LVL 2

Author Comment

by:chrisryhal
ID: 22787762
says that AddDays is an unrecognized identifier
0
 
LVL 12

Accepted Solution

by:
jgv earned 2000 total points
ID: 22787814
SSRS does not recognize the method in the expression window but it will work when you run the report
0
 
LVL 2

Author Comment

by:chrisryhal
ID: 22787870
Actually, I got it to work after messing with what you originally gave me:

=Format(Today().AddDays(-1), "dd-MMM-yy")

Thanks for the tip and the crutch to get me here :)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

715 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