Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where the most recent date's comments should be displayed in a text box. Currently it results in a hyphen (-). If I substitute the ReturnComments field with the ReturnDate field as the field to be displayed, I get the date (9/1/2020) displayed. Mystified why a hyphen is the result for the comments?
ReturnDate | ReturnComments |
2/19/2020 | Summary comments A |
5/26/2020 | On 5/26 These comments were made. |
9/1/2020 | This summary from 9/1 provides insights to…. |
This is one of my attempts:
=Only({$<(max(date(ReturnDate)))>}[Return Comments])
Hi @PaReD_SF85
Try like below
=Only({<ReturnDate={"$(=Date(Max(ReturnDate),'M/D/YYYY'))"}>}ReturnComments)
Thank you MayilVahanan! This worked perfectly. What a difference a missing set of quote marks makes!
Hi @PaReD_SF85
Try like below
=Only({<ReturnDate={"$(=Date(Max(ReturnDate),'M/D/YYYY'))"}>}ReturnComments)
Thank you MayilVahanan! This worked perfectly. What a difference a missing set of quote marks makes!