i am working on a report where i need to find the earliest date when the status was changed to X. I am using minimum function but it is giving me blank date , i am guessing because it treats the blank date as minimum.

 

Can someone advice on how can i calculate minimum date and if minimum date is blank then pull the next not null minimum date.

 

What i have tried is

1) supress null in details and then calculate minimum - didnt work

Code

//{@Active Date}= cdate(0,0,0)
//or
//totext({@Active Date})= ""
//

 

2) find minimum and then if null add next minimum - didnt work
IF minimum({@Active Date},{@Groupbycust})= cdate(0,0,0)
or
totext(minimum({@Active Date},{@Groupbycust}))= ""
THEN minimum({@Active Date},{@Groupbycust}) + 1
else
minimum({@Active Date},{@Groupbycust})