I use a filter to display some dates associated with a record.
This will return a list of dates as expected.
6/3/2019, 6/15/2019, 6/25/2019, 6/28/2019, 6/29/2019
Now I would like to only display latest date which is - 6/29/2019
So I modify the function to:
Which results in the incorrect date 6/15/2019.
Wrong argument type
Max expects parameter value to be a number, a list of numbers, a date/time value, a list of date/time values, a formatted number, a list of formatted numbers, a percentage, a list of percentages, a currency amount, a list of currency amounts, a time duration, or a list of time durations, but found History.Filter(Content=thisRow), which can match a table, or a table.
I also tried the following function:
Which again results in a different date - 6/3/2019
Can anyone please let me know how to display the last date?
Thank you in advance!!