Wrox Programmer Forums
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old February 28th, 2008, 07:39 AM
Registered User
Join Date: Feb 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Leap Year Calculation in SSRS


I am using SSRS interface to create and schedule a report.

The report parameters are as below...

Start Date: 01/03/2008 (dd/mm/yyyy)
End Date: 12/12/2009 (dd/mm/yyyy)
Schedule Details: Monthly (Feb) on 29th

Which means the report should not execute as 29th Feb will not appear on 2009. This date will come only in 2012 which is a leap year.
What SSRS does is, it creates a report and schedules it on 29th March 2009 (29/03/2009)
Which is wrong.
We have tried this issue several times with different date combination and the result was same.

Did any one come across this type if issue? If yes please let me know the solution.

With regards


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP 3.0 and SSRS? donm Reporting Services 0 September 26th, 2007 07:03 PM
Year Validation jputhra SQL Server 2000 1 December 10th, 2004 10:03 AM
Fiscal Year jemacc SQL Server 2000 4 October 7th, 2004 03:05 AM
A week of the a year cirudinezidane Javascript 2 July 1st, 2004 09:31 AM
leap years & cal_days_in_month richard.york Pro PHP 4 December 27th, 2003 02:15 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.