date count
i have two columns and have to calculate the difference between startdate and enddate ?
can someone please help me
November 11th, 2011 9:59am
Use DATEDIFF ( d, startdate , enddate ). This will give you the difference in days.
http://msdn.microsoft.com/en-us/library/ms189794.aspx
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2011 12:22pm
Use DATEDIFF ( "d", startdate , enddate ). This will give you the difference in days.
http://msdn.microsoft.com/en-us/library/ms189794.aspx
November 11th, 2011 8:10pm
For SSRS: http://msdn.microsoft.com/en-us/library/aa337092(v=sql.100).aspx
e.g. "=DateDiff(DateInterval.Day, Fields!StartDate.Value, Fields!EndDate.Value)"
OR "=DateDiff("d", Fields!StartDate.Value, Fields!EndDate.Value)"
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2011 10:10pm
For SSRS: http://msdn.microsoft.com/en-us/library/aa337092(v=sql.100).aspx
e.g. "=DateDiff(DateInterval.Day, Fields!StartDate.Value, Fields!EndDate.Value)"
OR "=DateDiff("d", Fields!StartDate.Value, Fields!EndDate.Value)"
November 12th, 2011 5:59am
thank you i got difference in days but having problem getting difference in time.msmustard
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2011 10:12am
What is the problem?
You can get the difference in seconds by changing the interval to DateInterval.Second or "s".
November 15th, 2011 10:23am