declare @MyDate as date set @MyDate = '11/11/2012' SELECT DATEADD(year, DATEDIFF(year, 1, @MyDate), 0)
declare @MyDate as date set @MyDate = '11/11/2012' SELECT DATEADD(year, DATEDIFF(year, 1, @MyDate), 0)
STo find previous Saturday for given date declare @selecteddate date = '20111118'; SELECT DATEADD(DAY, (DATEDIFF(DAY, '19000106', @selecteddate) - 1) / 7 * 7, '19000106') previous_saturday; GO To find Previous Sunday declare @selecteddate date = '20111118'; SELECT DATEADD(DAY, DATEDIFF(DAY, '18991231', @selecteddate) / 7 * 7, '18991231') GO
There are a few of you out there that have asked why the order of the Weeks in the OLAP cube have Week10 before Week6 – this hotfix addresses this ordering/sorting issue and a couple others. Description of the Office Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): October 25, 2011 This article describes the issues […]
Folks the October 25th, 2011 Project Server 2010 hotfix includes a few specific areas that you may have run across. Consider these when choosing to deploy this hotfix, also make sure to read the complete Cumulative Update article (listed at the end of this posting). Description of the Project Server 2010 hotfix package (Pjsrvwfe-x-none.msp): October […]
Thank you all who joined my session on Project 2010: Tips and Tricks that I delivered for MPUG last week. Your e-mails and messages were nice and I am glad it was helpful. Some of you asked about the recording and the Quick Access Toolbar link. They have both been published…Here you go. Also let […]
Good Afternoon Folks, My webcast that I delivered for MPUG last week included reference to my Quick Access Toolbar sample. I find it extremely helpful for better navigation and resource management with Microsoft Project 2010. My Quick Access Toolbar will allow you to start your own standard toolbar and you can share it with your […]
If you have ever used SSRS, you’ve probably run across an issue where HTML tags are displayed in your reports output like so: (CHAR(13) + CHAR(10)1.& Increase clarity on printed invoices, resulting in reduced manual intervention for scanning errors. 2). One way to get rid of this is to locate the field in question, then […]
Meeting Announcement: Join the MPUG Boston Chapter for… “How MS Project Saved My Life” (or at least helps me do my job!) Register Here Waltham, MA - On Wednesday November 30, 2011, The Boston Chapter of MPUG (Official Industry Association for Microsoft Project) will be holding a membership meeting. This interactive presentation and discussion will […]
Folks, I have had several conversations with several clients, the MSFT product team, fellow peers and it all boils down to the fact that each organization has their own preferences when archiving projects. What do you do? I thought to include a link that is one way and I will also expand on this posting […]