Help

Nested IF with MAX formula, comparing dates

Topic Labels: Formulas
Solved
Jump to Solution
2240 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!