Skip to Content
0
Former Member
Dec 03, 2011 at 02:04 AM

How to get the maximum value of 3 fields in crystal report

3202 Views

Hi,

I have 3 date fields in my report and I need to get the maximum value

example

creationdate =2011-01-01

updatedDate=2011-01-15

testdate=2011-01-20

I am trying to use the formula

maximum(creationdate ,updatedDate,testdate) but I am getting an error message.

Is there a way to do this informula.

Thanks in advance.

MM