maximim for the two different date and then maximum of those two date

[sat6845]

Help!!.

My objective to find the maximim of date1 first and find the maximim of date 2 and then the maximum of above maximim

First I had to find Maximim of Date 1 and the MAximim of Date 2 for an ID and then find the which is greater betwen those to maximim date

I had to Field Date1 and Date2 for a person.

The formula work fine and pick the correct value but I need to sort ascending of that date, but it do'nt show either on grouping or sort.

here is the formula
dtAryLatestContactDate := [max(date1,ID), max(date2,id)]

max(dtAryLatestContactDate)

 

[dgillz]

Maximum(Maximum({Date1,ID}),Maximum({Date2,ID}))

Do not use variables for this if you want to sort by it.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz