Avoiding empty dates while using Minimum aggregation

Hello,

I've set the aggregation method to be Minimum for a date key figure. For a particular key value, if there are blank dates then it is displayed as the minimum value in the data target. I want the non empty minimum. I tried

setting

if not comm_structure-date_field is initial.

result = comm_structure-date_field.

endif.

in the update rule. but not working. I do not want to skip the record as there are other values in that record i would need.

please advice.

regs

Anoop