Select Latest Date from several dates 2

[danny118088]

Hi All...

I'm relatively new to Crystal XI report and now facing problem with Dates formula.

Data structure:
PO Number|Creation Dt|Posting Dt|Doc Dt |Released Dt
x 01/01/09 01/15/09 - 03/03/09

From above data sample, I would like to display the latest date only by comparing all 4 fields.

Expected result :
PO Number|Last Updated Dt (from Formula)
x 03/03/09

I'm trying to use DateDiff but it would take long lines to capture all combination. Is there any other way to handle this?

Thank you in advance for the help.

cheers,
D

 

[Madawc]

You need DateDiff to find the number of days, or whatever. Crytal will allow you to compare two dates and see which is greater.

if {Creation Dt} > {Posting Dt}...

Test all possible combinations. No short-cuts, as far as I know.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Convert each of the four fields in a formula like this:

//{@docdt}:
if isnull({table.docdt}) then
date(0,0,0) else
{table.docdt}

Then create a formula like this to do the comparison:

maximum([{@createdt},{@postdt},{@docdt},{@releasedt}])

-LB