Solved

Convert DateTime to String in SSRS

Posted on 2008-10-21
3
5,969 Views
Last Modified: 2012-05-05
The datetime field is 5/15/08

My expression I have tried:

format(Fields!CHECKDATE.Value, "mmddyy")
              RESULT:  001508

Seems to be dropping the MM (month) but everything else is correct.  Kinda strange.

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
3 Comments
 
LVL 39

Expert Comment

by:appari
ID: 22767434
try

format(Fields!CHECKDATE.Value, "MMddyy")
0
 
LVL 39

Accepted Solution

by:
appari earned 500 total points
ID: 22767444
i think
mm is minutes
MM is month
0
 
LVL 2

Author Closing Comment

by:chrisryhal
ID: 31508292
Geesh, didn't know it was case sensitive.  So I was right other than that.  I appreciate your help.  
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

735 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