Minimum date between two date fields

[Almie]

Running CR10 against a Informix database.
In my main report, I have a sentence date, where date can be null. In my subreport, I have a receipt date, with receipts date can be null. I've created a shared variable to pull the receipt date and placed the formula in the group footer.

I need to find the minimum date between the sentence date and the receipt date.

Addressing the null date values:
If sentence date is null, the receipt date would be the minimum date. If receipt date is null, the sentence date would be the minimum date.


Can anyone help?

 

[synapsevampire]

Assumming there's only one sentence date per group:

whileprintingrecords;
shared datevar {@receiptdate};
if isnull({@receiptdate})
and
isnull({table.sentencedate}) then
"N/A"
else
if isnull({@receiptdate})
and
not(isnull({table.sentencedate})) then
{table.sentencedate}
else
if isnull({table.sentencedate}) then
and
not(isnull({@receiptdate})) then
{@receiptdate}
else
if {@receiptdate} <= {table.sentencedate} then
{@receiptdate}
else
{table.sentencedate}

-k