This is a migrated thread and some comments may be shown as answers.

Calculate Date Differece

2 Answers 181 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Nick
Top achievements
Rank 1
Nick asked on 02 Mar 2017, 02:39 PM
We cannot determine how to calculate date differences in Expressions (usage example: highlight a row if the Current Date is 7+ days past the Due Date). There appear to be very limited date manipulation functions that can be used in Expressions.

2 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 02 Mar 2017, 07:33 PM
Hello Nick,

You can use custom functions and aggregates to perform more complex calculations over data.

I hope this helps.

Regards,
Stef
Telerik by Progress
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
-1
Cecilia
Top achievements
Rank 1
answered on 07 Mar 2017, 06:27 PM
Perhaps another way to handle this is to do your date calculation within the query and create a column with your result. Then code the report to do compares against the value in the new column. 
Tags
Report Designer (standalone)
Asked by
Nick
Top achievements
Rank 1
Answers by
Stef
Telerik team
Cecilia
Top achievements
Rank 1
Share this question
or