Creating reports and dashboards | Stimulsoft community forum

Hi

i have two dates in my report. ASOF_DATE1 and ASOF_DATE2. I need to compare the dates in such manner that ASOF_DATE1 is less then or equal to 1 year prior to current month date which is ASOF_DATE2. I have tried doing this by below mentioned logic.

IFF( (ASOFDATE1 <= (DateTime.Parse("ASOF_DATE2").AddYears(-1))), "-", "ABC")

but this comparison is not done and blank space is shown.
Please suggest.

Thanks

Hello.

What type of the dates? It seems that the dates was not parsed correctly.
If you need any additional help, send us a sample report template that reproduce the issue.

Thank you.

I am attempting to list the newest date from three different databands. I have tried to use nested IFF Statements but that produces an error. So I can only compare two dates in an IFF. is there another way to do this?

Hello.

Do you use native Silverlight or client/server version?
The native Silverlight has limited support of expressions.

Thank you.