Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Nested IF with MAX formula, comparing dates

Topic Labels: Formulas
Solved
Jump to Solution
4052 3
cancel
Showing results for 
Search instead for 
Did you mean: 
kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

Hello!

Pulled up a list of three dates from a linked table.  In this table, there is a separate date on each record.  

Looking for a way to find the latest of the three dates, that is not later than the separate date in the record.  I can find the last date using MAX, but am struggling to integrate the IF statement of not surpassing the stand alone date on the record.  

3 Solutions

Accepted Solutions
Abdullah_Yuksel
6 - Interface Innovator
6 - Interface Innovator

Abdullah_Yuksel_0-1680305848921.pngAbdullah_Yuksel_1-1680305881284.png

Ekran görüntüsü 2023-04-01 023842.png

Ekran görüntüsü 2023-04-01 023828.png

Ekran görüntüsü 2023-04-01 023833.png

I hope the screenshots I shared are explanatory ðŸ˜Š

See Solution in Thread

kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

Thanks! 

Unfortunately that solution doesn't work for my use case.  This is part of an HR base.

1) Employee is listed on one table
2) On a separate table we list out effective dates for their salaries
3) Goals, of different types, are connected to an employee's salary.  On this table I am looking to pull up each employee's salary by date in order to establish yearly goals.  Salary's and hence goals change so I can't simply rely on latest.

This solution appears to work if I had one date reference back to the second table but there will be multiple.   



See Solution in Thread

kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

I was able to revise my base design and use the solution provided, thanks!

See Solution in Thread

3 Replies 3
Abdullah_Yuksel
6 - Interface Innovator
6 - Interface Innovator

Abdullah_Yuksel_0-1680305848921.pngAbdullah_Yuksel_1-1680305881284.png

Ekran görüntüsü 2023-04-01 023842.png

Ekran görüntüsü 2023-04-01 023828.png

Ekran görüntüsü 2023-04-01 023833.png

I hope the screenshots I shared are explanatory ðŸ˜Š

kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

Thanks! 

Unfortunately that solution doesn't work for my use case.  This is part of an HR base.

1) Employee is listed on one table
2) On a separate table we list out effective dates for their salaries
3) Goals, of different types, are connected to an employee's salary.  On this table I am looking to pull up each employee's salary by date in order to establish yearly goals.  Salary's and hence goals change so I can't simply rely on latest.

This solution appears to work if I had one date reference back to the second table but there will be multiple.   



kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

I was able to revise my base design and use the solution provided, thanks!