Range between two dates

[Esteban]

Hi,

How to make a range between two dates in a grid?

Many Thanks,
Sakn

[Alexander Valchev]

Hi Esteban,

You can define a column with a template and call a JavaScript function that calculates the difference.
For example:

//Column definition
{
    title: "Difference",
    template: "#= calculateDates(firstDate, secondDate) # days"
}

function calculateDates(first, second) {
    var diff = Math.round((second - first)/1000/60/60/24); //Difference in days
    return diff;
}

I hope this information helps. In the attachments you can find a sample project showing this approach in action.

Kind regards,
Alexander Valchev
the Telerik team

[Esteban]

Thank you for the answer