Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
PaReD_SF85
Contributor III
Contributor III

Display field in Text box results in a hyphen

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?

ReturnDateReturnComments
2/19/2020Summary comments A
5/26/2020On 5/26 These comments were made.
9/1/2020This summary from 9/1 provides insights to….

 

This is one of my attempts: 

=Only({$<(max(date(ReturnDate)))>}[Return Comments])

2 Solutions

Accepted Solutions
MayilVahanan

Hi @PaReD_SF85 

Try like below

=Only({<ReturnDate={"$(=Date(Max(ReturnDate),'M/D/YYYY'))"}>}ReturnComments)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

PaReD_SF85
Contributor III
Contributor III
Author

Thank you MayilVahanan! This worked perfectly.  What a difference a missing set of quote marks makes! 

View solution in original post

2 Replies
MayilVahanan

Hi @PaReD_SF85 

Try like below

=Only({<ReturnDate={"$(=Date(Max(ReturnDate),'M/D/YYYY'))"}>}ReturnComments)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
PaReD_SF85
Contributor III
Contributor III
Author

Thank you MayilVahanan! This worked perfectly.  What a difference a missing set of quote marks makes!