Report level solution for finding Max date from 3 columns

[DrSmyth]

Hi,

I've just come across a new problem that i've not encountered before and was wondering if anybody had a solution.

Basically i've got a report with three columns of dates in it. Each row may have one two or three dates. I need to create an object that will give me the latest of the three possible dates for each row.

Now I think i might be able to get around it with an if then else statement, but thought there may be a better solution..

Does anybody have any ideas?

Smyth

 

[skrandel]

That's a truly great question. The issue is that BO's MAX function can only take 1 parameter.

I think you have to do the if-then-else stuff in order to resolve this one.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com