Info-lake
Knowledge sharing....
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.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)