DanielJohnson2
4 years agoQrew Trainee
Formula Syntax Error Question
Hi All,
Here's the formula I thought would work:
todate(max(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1)))
The logic is, find all records where fid 756 (related field) in table abdc3n4ne equals the record ID in the table where this formula is, then of those records tell me the values in the Date Created field, then just tell me the most recent of those dates (what I thought the max formula would do) then turn it into just the date.
I'm getting a syntax error. The second ) after the 1 at the end is highlighted yellow and the error box says "Expecting," but that's for the max function, which I didn't think needed a comma.
Thoughts?
------------------------------
Daniel Johnson
------------------------------
Here's the formula I thought would work:
todate(max(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1)))
The logic is, find all records where fid 756 (related field) in table abdc3n4ne equals the record ID in the table where this formula is, then of those records tell me the values in the Date Created field, then just tell me the most recent of those dates (what I thought the max formula would do) then turn it into just the date.
I'm getting a syntax error. The second ) after the 1 at the end is highlighted yellow and the error box says "Expecting," but that's for the max function, which I didn't think needed a comma.
Thoughts?
------------------------------
Daniel Johnson
------------------------------