CERT_LINE::EXP_DATE > GetAsDate ( Get ( CurrentHostTimeStamp ) ) + 30 ;
Let ( [
a = "AWCT Arduous WCT" ;
b = "I-100 Introduction to Incident Command System" ;
c = "IS-00700 National Incident Management System: An Introduction" ;
d = "L-180 Human Factors in the Wildland Fire Service" ;
e = "RT-130 Annual Wildland Refresher Course"
FilterValues ( CERT_LIST ; List ( a ; b ; c ; d ; e ) )
I would definitely recommend that you study the alternative formula structure suggested by erolst, and teach yourself to use the Let ( ) function. However, there appears to be a problem with the formula you have posted anyway. I assume each of the If()s is meant to be a condition which must be met; if so, wherever you have "&" you need to use "and" instead.
I am working on an application that I did not create. It functions as it is so I don’t want to break it. I just need to figure out how to make the calculation to include the date…. There is another element that is related to the way it functions, I will analyze the complete structure and try to map it out logically. I am not very familiar with filemaker scripting functions so I am a little lost, but I understand the underlying logical structure and have some knowledge of database design in a sql environment (aside from a journey into filemaker in ….my god 1991 or 2………thanks for looking at this, I really do appreciate it…
I assume each of the If()s is meant to be a condition which must be met; if so, wherever you have "&" you need to use "and" instead.
I thought so, too, upon seeing the word “validation”; but reading the text indicates that the original calculation was intended to return a list result – also note the inserted pilcrows – with each value's presence conditional, and that the term does not refer to “field validation”.
thanks for looking at this, I really do appreciate it…
Why, you're welcome …
Ah, yes. No substitute for close reading of the detail!