Compare Multiple Dates - Publish Newest

[jebsen]

I am attempting to to find the newest date from data in three different databands and publish it to the first databand. I have tried many different ideas. When i use am IIF statment it errors out if I nest another IIF statement. So the IIF statement only compares two dates. Any suggestions?

[HighAley]

Hello.

What error do you get?
Please, send us a sample report template with data.

Thank you.

[jebsen]

Here is the report

Please see the formula residing in 3.18. Is there a better way to do this? I simply want to find the latest changes that were made from an 'Updated' date field that resides in three different tables.

The error produced on checking the expression says "There is no matching overloaded method for 'IIF(Object,Object,Object)'

[HighAley]

Hello.

If you need to compare dates, you could use next expression:

Code: Select all

{IIF(Variable1>Variable2,IIF(Variable1>Variable3, Variable1, Variable3), IIF(Variable2>Variable3, Variable2, Variable3))}

The variables have date type.

Thank you.

[jebsen]

Thank You. However it is giving me an error. The error produced on checking the expression says "There is no matching overloaded method for 'IIF(Object,Object,Object)'

[HighAley]

Hello.

Maybe we missed something.
Please, send us your report template with sample data.

Thank you.

[jebsen]

it is in the post above.

[HighAley]

Hello.

To help you we need to reproduce the issue.
We can do this without sample data.

Thank you.

[jebsen]

What is the best way to submit the data? an excel file? It is simply a question of three dates from three tables.

[HighAley]

Hello.

Please, send us any simple report template that reproduces the issue. If it's necessary, you could use our Demo data.

Thank you.