working with FMP blank fields

Thread View: comp.sys.mac.databases

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by cicone Fri, 13 Nov 1992 22:25

#410

Author: cicone
Date: Fri, 13 Nov 1992 22:25

23 lines
1470 bytes

 Hello,	
	Has anyone out there come up with a work around for FileMakerPro (1.0v2) that
would allow the use of the 'If' function in a calculation field that references
a date field that does not yet contain a value?  The actual calculation I would
have liked to use:

If (Length (paper accepted) >0 ,"Accepted",If (Length (paper rejected) >0 ,
"Rejected" , "In Progress"))

	where 'paper accepted' and 'paper rejected' are both date fields.  As the FMP
manual states if a field doesn't contain a value the 'If' function is skipped
altogether and returns an empty result. If either of the date fields has a
value entered into it the calculation works fine; if both fields are blank I
get no result.  
	I attempted a few ways around this but it seems that none of the functions
available in a calculation field will work with a blank field....
Thanks in advance...
--Bob--
**********************
Bob Cicone (cicone@uieea.ece.uiuc.edu)
Sys Admin
Bioacoustics Research Lab
University of Illinois at Urbana-Champaign

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads