On 2/12/19 2:48 PM, Rich Shepard wrote:
On Tue, 12 Feb 2019, Rich Shepard wrote:A.next_contact = (select (max(A.next_contact)) from Activities as A)Errata: The parentheses around the max aggregate are not necessary. A.next_contact now displays at the end of each returned row as 'infinity'.
'infinity' is the max date, so this is what you want?
Rich
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
