SteveFairclough
IS-IT--Management
I'm trying to use the "Min Of" summary function on a date field that is not always populated. The problem I have is that if just one of the dates is a null value then the "Min Of" function doesn't display anything on the group summary line.
I've tried to get around it by using a formula where the date field should be and then populating it with Date(3099,1,1) if the date field is a null value. However, this is not really acceptable due this field being included in some other date calculations in the report.Ideally, I just want to leave the null dates as null dates.
Does anybody know a way to get around this ?
I've tried to get around it by using a formula where the date field should be and then populating it with Date(3099,1,1) if the date field is a null value. However, this is not really acceptable due this field being included in some other date calculations in the report.Ideally, I just want to leave the null dates as null dates.
Does anybody know a way to get around this ?