?
Solved

show formated date in reporting services

Posted on 2007-04-10
1
Medium Priority
?
745 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
1 Comment
 
LVL 10

Accepted Solution

by:
RichardCorrie earned 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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…
Integration Management Part 2
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 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