Hi guys,
I have two fields on a report (start date and end date) and I'd like to create a calculated field showing the number of hours. I can't find any date formatting functions such as datediff, datepart etc that would allow me to do this. Any ideas? I guess I could add a field to the sql server view but it would cause complications in another tier...
I have two fields on a report (start date and end date) and I'd like to create a calculated field showing the number of hours. I can't find any date formatting functions such as datediff, datepart etc that would allow me to do this. Any ideas? I guess I could add a field to the sql server view but it would cause complications in another tier...
2 Answers, 1 is accepted
-1
Accepted
Hello Steven,
There is no built-in datediff function, but you can accomplish the desired functionality by utilizing an User Function.
All the best,
Steve
the Telerik team
There is no built-in datediff function, but you can accomplish the desired functionality by utilizing an User Function.
All the best,
Steve
the Telerik team
Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!
0
Steven
Top achievements
Rank 1
Rank 1
answered on 29 Jul 2011, 12:33 AM
Wohoo, I have control! That's even better- thanks!
Some general feedback: I have a WPF app I needed to add reports to, and I spend a couple of DAYS banging my head against a wall with the CRap reporting tool of a competitor (It couldn't handle WPF + themes). I downloaded your reporting and everything just... worked. If deployment is as easy as this, call me a telervangelist.
Some general feedback: I have a WPF app I needed to add reports to, and I spend a couple of DAYS banging my head against a wall with the CRap reporting tool of a competitor (It couldn't handle WPF + themes). I downloaded your reporting and everything just... worked. If deployment is as easy as this, call me a telervangelist.