Solved

show formated date in reporting services

Posted on 2007-04-10
1
732 Views
Last Modified: 2008-01-09
In reporting services I show today's date with the expression: =Globals!ExecutionTime.ToShortDateString.
the date of april 10 is shown  04/10/2007 and I want to get 04/10/2007 or the date i words.
How do I so it?
Anat
0
Comment
Question by:ANAT2403
[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
1 Comment
 
LVL 10

Accepted Solution

by:
RichardCorrie earned 500 total points
ID: 18882578

try
=Globals!ExecutionTime.ToString("d MMM yyyy")

the .ToShortDateString relys on the regional settings of the server - looks like it is set to US rather than UK settings.

tha above will give date in format 10 Apr 2007

/Richard
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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