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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics