Solved: SUM, MAX of many date columns per row to find late... - Page 2

Steve_Chambers · 02-12-2021 07:32 PM

Hi guys.

I have an “Orders” table that has 9 columns that track a changetimestamp on the [Progress] and I am wanting to give the user the ability to: order by the most recently updated progress. So in a VC i am looking at:
MAX([Creation Date Stamp],[Quote Sent Date],[Deposit Paid Date],[…])
and then wrap this in a SUM(MAX()TODAY+1) to give a final result of:

If that makes sense? I am struggling with the MAXROW expression

Suvrutt_Gurjar

Thank you @Steve_Chambers . Good to know it basically works.

You are correct. please wrap the result by HOUR()

Maybe something like

HOUR((TODAY()- MAX(
LIST(
DATE([Creation Date Stamp]) ,
DATE([Quote Sent Date]) ,
DATE([Deposit Paid Date]) ,
DATE([Confirmation Sent Date]) ,
DATE([Production Start Date]) ,
DATE([Production End Date]) ,
DATE([Invoice Sent Date]) ,
DATE([Invoice Paid Date]) ,
DATE([Follow-up Letter Sent Date])
)))) / 24

Please refer the first duration expression example in the article below under the section " Examples that Compute Durations in Days, Months, or Years"

View solution in original post

SUM, MAX of many date columns per row to find latest timestamp