I have a subform in an eForm, where the user enters a few inputs, one of them is a date.
I need to calculate the Latest date entered, so once this latest date has passed, I can send the user a notification with a new assignment.
For example if the user entered 3 dates : Feb 06 2021 , Oct 12 2021 , July 22 2021
I need a variable to get Oct 12 2021 - so I can send him a notification after this date.
Maybe there is a different way of achieving this? I've manage to calculate the number of days from *now* to each of the entered days, but still cannot find a MAX function. (There how ever a SUM function that sums all variables in a subform).
Would appreciate some help
Please sign in to leave a comment.