(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › @MIN programing
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic @MIN programing (Read 585 times)
drgregory
Member
*
Offline


No personal text

Posts: 9
Joined: Jan 17th, 2004
@MIN programing
Jan 17th, 2004 at 6:04pm
Print Post Print Post  
I am trying to get a minimum date from a list.  It contains some blanks.  When I calculate it returns 00-00-0000.  How can I get it to ignore the blanks? Here is the program.

F0003 = @MIN(F0009,F0017,F0025,F0033,F0041)

Thanks  Dave
  
Back to top
 
IP Logged
 
Alec
Lanticans
*****
Offline



Posts: 200
Location: Ascot, England, UK
Joined: Nov 22nd, 2002
Re: @MIN programing
Reply #1 - Jan 17th, 2004 at 10:29pm
Print Post Print Post  
I see that Q&A ignores blank fields in this context, giving the Min of just the actual >values< but Sesame treats a blank field as a zero date and shows that.
We'll look into this.

BTW I see that you also sent a support request email. Would you not do that please, otherwise there's a likelihood of two people duplicating each other's effort. Thanks.
  
Alec
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge