SSRS Date Formats

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))
rwheeler23Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sureshbabukrishConnect With a Mentor Commented:
It should be as simple as this
="Date of Report: " & Globals!ExecutionTime.ToLongDateString()
0
 
Christopher GordonSenior Developer AnalystCommented:
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
 
rwheeler23Author Commented:
All I wanted was the date to appear as:

Friday, March 18, 2011. I will attempt your code on Monday. Thanks.
0
 
rwheeler23Author Commented:
That was a lot simpler than what I was trying to do.
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.