Hello,

This might help you, rather than doing into SSRS, create new datasource and use below code for your parameter

[Code]

DECLARE @Day INT

SET @Day = datePart(dd,getDate())

IF @DAY < 21

BEGIN

SELECTCONVERT(VARCHAR(25),(dateAdd(MONTH, dateDiff(MONTH, 0, getDate()),...

Thanks for useful informations!

Gaps are normal then it's fine, i thought i was missing something.

You are a Super Star!!!! Great!!!

Hello Everyone,

We had same situation where we had application front end in Access 2003 and Backend SQL Server 2005, runs fast no probs.

Now we upgrade Access 2007 noticed perfomance issue,...

DECLARE @MyDate DATETIME SET @MyDate = getDate()

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME

SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, @MyDate)) - 4)%12), @MyDate ) - datePart(d,DATEADD( mm, -(((12...

FORMAT(now,"dd/MM/yyyy")