Thursday, March 22, 2012

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

Try this:

= IIF( CDate(First(Fields!EndDate.Value)) > CDate(First(Fields!StartDate.Value)), "ERROR!", "OK!")

No comments:

Post a Comment