Subtract date

[Felice]

I need to subtract two date from dateTimeColumns.

I tried in the designer:
DATEDIFFDAY(Periodo, Data_Pagam), in the designer

I tried with the code:

 radGridView1.Columns["Ritardo"].Expression = "Periodo-Data_Pagam";

I keep getting this error:
Invalid Expression:
"Cannot perform '-' operation on System.DateTime and System.DateTime

Please help.

[Dimitar]

Hello Felice,

Thank you for writing.

You should specify the appropriate parameters directly when you are initializing the expression:

radGridView1.Columns["Duration"].Expression = "DATEDIFFDAY(StartTime ,EndTime)";

Also I have attached a sample project that contains a sample implementation for such functionality.

I hope this will be useful. Should you have further questions, I would be glad to help.

Regards,
Dimitar
Telerik

[Felice]

Thank you, you solved my problem.