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
Solved

SSRS Date Formats

Posted on 2011-03-18
4
948 Views
Last Modified: 2012-05-11
I am trying to format the dates to be shown as:

Friday, March 18, 2011

Why does this statement keeps complaining about converting an integer to a string?

="Date of Report: "+WeekDayName(WeekDay( Globals!ExecutionTime), 0)+", "+MonthName(Globals!ExecutionTime,0)+ str(DatePart("Day", Globals!ExecutionTime))+", "+str(DatePart("Year", Globals!ExecutionTime))
0
Comment
Question by:rwheeler23
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Christopher Gordon
ID: 35172484
Is this what you're trying to do?

="Date of Report: "+ WeekDayName(WeekDay(Now()),0)+ ", " + MonthName(Month(Now())) + Day(Now()).ToString() + ", " + Year(Now()).ToString()
0
 

Author Comment

by:rwheeler23
ID: 35173527
All I wanted was the date to appear as:

Friday, March 18, 2011. I will attempt your code on Monday. Thanks.
0
 
LVL 9

Accepted Solution

by:
sureshbabukrish earned 500 total points
ID: 35179068
It should be as simple as this
="Date of Report: " & Globals!ExecutionTime.ToLongDateString()
0
 

Author Closing Comment

by:rwheeler23
ID: 35184217
That was a lot simpler than what I was trying to do.
Thank you.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
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…

828 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