Create lookup for latest date

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I created an Actual Completion Date field but i want it to get the latest date from the list of dates.

I have a project that has many task with different date so I want to get the latest date from the list of task. 

Notes:

Project & Task are a different table but in a relationship with one another

the Project has many task

i want it to show the latest date from all of the task



eg. 

project 12

task      end date

1           Jan 5

2           Jan 6



Actual Completion Date = Jan 6

Photo of Ann

Ann

  • 22 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
No problem. Just go to the relationship where one project as many tasks and on the left side of the relationship there will be a button to add Summary field.

Then select the maximum or minimum of the date field as your Summary field.
Photo of Ann

Ann

  • 22 Points
it works! thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
:smile:  from Italy. That's where I'm at now.
Photo of Ann

Ann

  • 22 Points
from the philippines. :smile:
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,074 Points 20k badge 2x thumb
from Earth. That's where I'm at now.
Photo of Ann

Ann

  • 22 Points
LOL! thanks guys for all your help! :relieved: