AnsweredAssumed Answered

Record search within a custom function

Question asked by JTG on Nov 21, 2016
Latest reply on Nov 21, 2016 by JTG

The database I'm working on has a calculated field in a table.  This field holds the number of working days between an initial date (stored in the same table) and the current date obtained with the Get(CurrentDate) function.


The difficulty is that I need to take into account vacation days stored in another table.  The working days calculation is specific to a person and each person has his/her own unique vacation schedule.   I was thinking to do the calculation via a custom function, however, I have found no way to search a table from within a custom function.  Have I missed something about custom functions in this regard?


I would appreciate any suggestions about how to approach this problem using custom functions or otherwise.