Calculate past due date

[Kent Hoang]

in my DB, I have submit date & Due Date field.  I added a textbox & I try to calculate the past due date but it throw me an error
can someone help me with this?

= Fields.Date - Fields.[DueDate]  (I got error here)

[Svetoslav]

Hello Kent Hoang,

Currently Telerik Reporting does not support date calculations. Anyway there are a couple of ways to workaround this limitation:

• perform the calculations at the data source level. For example if the data comes from an SQL server you can subtract the dates in your SQL query;

• a user-defined function that performs the date calculations. For more information please see Using Expressions.

Regards,
Svetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Kent Hoang]

hmm, I'm trying to convert some of my Crystal Report to web base version.  My crystal reports have some advance calculation.  Date subtraction is just a simple thing & Telerik cannot do it?  It is so inconvenience.  You need to update your software please

Thanks

[Svetoslav]

Hello Kent Hoang,

Thank you for the feedback. Indeed this issue is already in our TODO list and it is just a matter of time when we will fix it. Until then it is best to stick with the suggested workarounds.

Regards,
Svetoslav
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Casey]

Has this issue been addressed? I'm trying to use ".AddDays" in one of my textboxes in the report, and it errors out. This would be a nice feature to have.

Thanks!
Casey

[Peter]

Hello Casey,

DateTime.AddDays method is expecting argument of type double. Check out the following sample expression:
=CDate("2013-03-13").AddDays(CDbl(1))

All the best,
Peter
the Telerik team

[Casey]

I have a DateTime property in my datasource. I'm trying to do MyDateTimeProperty.AddDays(MyDoubleProperty), and it isn't working.

I receive the following error:

"An error has occurred while processing TextBox 'textBox11': The expression contains undefined function call AddDays()."

Thanks!
Casey

[Peter]

Hi Casey,

Try the following expression:

=CDate(MyDateTimeProperty).AddDays(CDbl(MyDoubleProperty))

Greetings,
Peter
the Telerik team

[Casey]

Thanks Peter, this works. I was able to find it in the documentation too, now that I know what I should have been looking for... I wasn't aware that I would have to convert my DateTime object to a DateTime to use any of the DateTime methods.

Casey

[Doors]

Since 2009 still there is no DATEDIFF Function there must be very long TODO list

[Todor]

Hello Kerem,

You may subtract Dates and you will get the corresponding TimeSpan. For example, the following Expression returns the result '63.00:00:00':

= Date(2022, 10, 20) - Date(2022, 8, 18)

As another example, the next Expression will return the time of the current day:

= Now() - Today()

For more details, you may see the Date and Time functions we provide.