Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1440
  • Last Modified:

Format Date Expression in SSRS

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
chrisryhal
Asked:
chrisryhal
  • 2
  • 2
1 Solution
 
jgvCommented:
This should do it
=Format(Date.Today.AddDays(-1), "dd-MMM-yy")
0
 
chrisryhalAuthor Commented:
says that AddDays is an unrecognized identifier
0
 
jgvCommented:
SSRS does not recognize the method in the expression window but it will work when you run the report
0
 
chrisryhalAuthor Commented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now