Maxrow date

Hi,

Please help me with this: I want to get the most recent date from my virtual column(Related Remarks) and include it to my email body. I tried several syntax but it didn’t worked. Here are some screenshots of my app.

Related Remarks : on this image, I want to include the date and remarks of 9/23/2020 only

image

But everytime I’ve received an email from my app, it showed the 2 rows. the 9/23/2020 and 9/22/2020.

image

Please see below code of my email body(Workflow):

Project Name: <<[Project Name]>>
Description: <<[Description]>>
Start Date: <<[Start Date]>>
Status: <<[Status]>>
Phase: <<[Phase]>>
Classification: <<[Classification]>>
Platform(s): <<[Platform]>>
Rollout SD: <<[Rollout SD]>>
Rollout SA: <<[Rollout SA]>>
Project Resource: <<[Project Resource]>>
Transition Specialist: <<[Transition Specialist]>>
<<Start: [Related Remarks]>>
Remarks
Date:<<[Date]>>
Remarks :<<[Remarks]>>

<>

Try something like…<<Start:INDEX(ORDERBY([Related Remarks],[_Rownumber],TRUE),1)>>

2 Likes