June 27, 2012

Start Date and End date of the month


SELECT Convert(datetime , CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(Getdate())-1), Getdate() ),103),103) AS Date_Value 

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))Declare @FromDate  datetime   

June 14, 2012

SSRS Report Number Formating for Negative Values

Show negative numbers as (2,123) not -2,123.  


The SSRS number formats use '-' instead of ().  


Put 
Format code = ##,###,###.00;(##,###,###.00)
for that column.