mattdaddy.net info that bounces inside my brain that makes sense to me, maybe you.

3Sep/090

Geek Alert: How to get Week Ending in SSRS

I was having some issues trying to find the friday date on a report in SSRS (Sql Server Reporting Services). A bunch of our reports needed to be labeled with the following friday of the day it was run. Here's how I got it.

="Week Ending: " + dateadd("D",6-Weekday(today()),today())

the "Week Ending:" is so it would look like
Week Ending: 09/05/09

Filed under: Uncategorized Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

(required)

No trackbacks yet.

» «

Pages

What I'm Doing...

  • Looking for a template for a financial/investment data model. Still learning about the industry, want to start playing with some stuff. 1 day ago
  • Anyone know where I can find an Eagle/Pace Investment Systems consultant or consulting company? 4 days ago
  • #sqlhelp nevermind, helps if you look in the connection itself to see the query :) 5 days ago
  • #sqlhelp - I have a query I'd like to save to excel and have it refresh everytime someone runs it. Am I missing something? 5 days ago
  • just getting started in the financial industry. Any advice on getting a Data model for a securities db? I'm still learning what a call is! 1 week ago
  • Anyone see Avengers? Can't believe I couldn't see it this weekend. 2 weeks ago
  • want to download sql 2012, is there a dev version? Want to build prototype for work to convince them to upgrade. #sqlhelp 2 weeks ago
  • Ah. where not (a1.country = 'US' and b1.country = 'US' and c1.country = 'US') #sqlhelp Thanks Mike! 2 weeks ago
  • where (a.1 <> 'US' and b.1 <> 'US' and c.1 <> 'US') isn't working. #sqlhelp 2/2 2 weeks ago
  • where (a.1 <> 'US' and b.1 <> 'US' and c.1 <> 'US') isn't working. 2 weeks ago
  • More updates...

Posting tweet...

Powered by Twitter Tools