Print Page | Close Window

MINIMUM function on a date column with null dates

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19437
Printed Date: 02 May 2024 at 7:49pm


Topic: MINIMUM function on a date column with null dates
Posted By: anushka
Subject: MINIMUM function on a date column with null dates
Date Posted: 17 Apr 2013 at 7:00am
Hi
 
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
 
2) find minimum and then if null add next minimum - didnt work
IF minimum( mailto:%7b@Active - {@Active Date},{@Groupbycust})= cdate(0,0,0)
or
totext(minimum( mailto:%7b@Active - {@Active Date},{@Groupbycust}))= ""
THEN minimum( mailto:%7b@Active - {@Active Date},{@Groupbycust}) + 1
else
minimum( mailto:%7b@Active - {@Active Date},{@Groupbycust})
 
 


Replies:
Posted By: DBlank
Date Posted: 17 Apr 2013 at 7:39am
can you post some sample data and how you want it calculated?


Print Page | Close Window