Max or Min of a Date Field

[NattyCat]

Crystal 9, SQL Server 7

I have a field {last run date} and I'm trying to display the earliest date that appears in that field.

I've used a formula:

{@min date}
minimum (database.last run date}

but this is returning blanks, even though i know I have a date of 9th feb and 14th feb in that field - and am trying to return the 9th.

Any ideas?

Nat

 

[dgillz]

You probably have nulls in your date field. I would address this in 2 steps:

1) Test for nulls:
If Isnll({YourDateField}) then date (2099,1,1) else {YourDateField}

2) Perform a minimum of this formula field rather then the database field.



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

http://www.srhconsulting.com