max formula help

[BlurredVision]

Hello All.

I have the following formula in my report header (Running CR 9)

Maximum ({@ES520Date});
Maximum ({@ES521Date});
Maximum ({@ES522Date});
Maximum ({@ES523Date});

I would like to take the above and do a max on those 4 items within the report header. Any ideas.. ? I tried
Maximum({@ES527Date},{@ES525Date}); but that won't work.

Thanks for your time... Brian

 

[mbarron]

Set it up as an array:

Maximum ([{@ES520Date},{@ES521Date},{@ES522Date}{@ES523Date}])


Mike

 

[bdreed35]

Try this:
Create a formula for your Report Header.
Place this in the formula:

dateVar array maxDate := [Maximum ({@ES520Date}),
                          Maximum ({@ES521Date}),
                          Maximum ({@ES522Date}),
                          Maximum ({@ES523Date})];
Maximum(maxDate)

~Brian

 

[mbarron]

My formula should have been:

maximum([Maximum ({@ES520Date}),Maximum ({@ES521Date}),Maximum ({@ES522Date}),Maximum ({@ES523Date})]]

which Brian has demonstrated.

Mike