Comparing dates

HI,

In my report there are two parameters,One is for StartDate and One is for enddate.Startdate must lessthan enddate.How to compare two dates in sqlserver report,and if send date is earlier than startdate how to display error message.

Thanks in advance

You can use the Parameters collection to reference the value of a parameter - Parameters!StartDate.Value. So you can compare the two dates like =IIF(Parameters!StartDate.Value > Parameters!EndDate.Value, "Error", "OK").|||

Hi,

where we have to write that iif condition.Please help me.

|||You can use the expression as the value of a textbox where you want to display the comparison result.