Solved

Convert DateTime to String in SSRS

Posted on 2008-10-21
3
6,092 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL query to summarize items per month 5 85
Help with simplifying SQL 6 54
user defined date datatype in SQL Server- can it be overdone.. 6 42
Are triggers slow? 7 29
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

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