I use a filter to display some dates associated with a record. History.Filter(Content=thisRow) This will return a list of dates as expected. 6/3/2019, 6/15/2019, 6/25/2019, 6/28/2019, 6/29/2019 Now I would like to only display latest date which is - 6/29/2019 So I modify the function to: …

I’m not at the computer right now, but I think I understand the problem. When you apply .Max() to a set of rows, it selects the max one NOT by filter condition (Max doesn’t know about filter condition at all) but perhaps by the display column (one with the bookmark icon). You should try replace .Ma…

Dear @Jimmy_C :bulb: Oldest date: 6/3/2019 Schedule.Date.min() Latest date: 6/17/2019 Schedule.Date.Max()

Thanks for the reply Jean! I have tried that and it indeed sets max date but for the entire column. History.Date.Max() I however need to use filter to only show dates associated for the row. History.Filter(Content=thisRow) This creates the list of dates, I just need to now only display the lat…

Hi, I am sorry running out of time, but please have a look to this post: [image] For each group, show row with most recent date Hi there, I’m new to Coda but enjoy what I see so far. I have a table with entries for various items. Each entry contains the item, a date and…

Hi, Thanks, I looked into it and looks like it does not apply to my situation :frowning: I might not be doing a good explanation of issue so will try to explain again. I have a table that pulls in date data from another table using a filter. History.Filter(Content=thisRow) Data displays in cell…

Dear @Jimmy_C This is the solution: [image] Schedule.Filter(Date).last()=thisRow

Hi Jimmy, this is something that confused me as well when I first ran into it. Think about what this formula is doing… [image] Jimmy_C: History.Filter(Content=thisRow).Max() You’re taking the history table as a whole and filtering it down. The filter works because it acts on the column you’v…

Thanks Paul. That did the trick :wink:

Hi @Paul_Danyliuk I’m struggling with something simular I need to select a row from a table that is the latest date before a date in current table. from that row I need a different value (jaarkost). [Salery lines].filter([salery date]<= EndOfMonth(Date(year,2,1),0)).cost.last() problem with th…

Doesn’t the .Sort([salery date]).cost.Last() do the trick? First you filter, then you sort so that the last row is the one with the highest date value, then select the last cost.

when I try .Sort([salery date]).cost.Last() I get an error (tried a lot of variations) but when I changed it to .Sort(true,[salery date]).cost.Last() It works thanks for putting me in the right direction

Last date using Max() - Not working!

Jean_Pierre_Traets June 18, 2019, 6:33pm 4

Hi,

I am sorry running out of time, but please have a look to this post:

Topic		Replies	Views
Filter rows equal to latest date Showcase & Tips	2	2087	May 24, 2020
How can I filter by the last row added?	7	1123	June 20, 2023
Filter based on most recent value but with another criteria	6	696	June 7, 2023
Display most recent date in a row based on criteria in a column?	6	952	December 22, 2022
Laste date before date	3	959	November 10, 2019

Last date using Max() - Not working!

Related topics