Expression, datediffday and week end

[ERIC]

Hello,

Is it possible to count the days separating two dates excluding weekends ?
Sorry if the topic has already been discussed, I did not find anything similar on the forum

Thank you in advance !

Best regards,

Eric

[Dimitar]

Hi Eric,

Thank you for writing.

To calculate business days only, you can use a custom expression function like the following one:

public class CustomExpressionContext : Telerik.Data.Expressions.ExpressionContext
{
    public double GetBusinessDays(DateTime startD, DateTime endD)
    {
       double   calcBusinessDays = 1 + ((endD - startD).TotalDays * 5 - (startD.DayOfWeek - endD.DayOfWeek) * 2) / 7;

        if ((int)endD.DayOfWeek == 6)
            calcBusinessDays--;
        if ((int)startD.DayOfWeek == 0)
            calcBusinessDays--;

        return calcBusinessDays;
    }
}

You can apply the function to the column like this:

Telerik.Data.Expressions.ExpressionContext.Context = new CustomExpressionContext();
this.radGridView1.Columns[2].Expression = "GETBUSINESSDAYS(col1,col2)";

I hope this information helps. Should you have any other questions, I will be glad to assist you.

Regards,
Dimitar
Telerik

[ERIC]

Hi,

Thank you very much it works as desired!

Best regards,

Eric