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