Why isn't my date lookup field working?

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

Here is my original table relationship:

1.) Accounts have many Contracts

There is a "Bill Date" field within the Related Contract that I'd like to carry over to the Related Account but when editing the table relationship, I can't select a summary field for the Bill Date.

So, I decided to create another table relationship but this time:

2.) Contracts have many Accounts

And I selected "Bill Date" as one of the lookup fields for my Related Account. However, the date is not showing up in the field under the Related Account and I don't know why.

Can someone please advise?

Thank you!

Photo of NP

NP

  • 10 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
OK, so 1 Account has many Contracts.  Which of the contracts are you looking to pull the date from, and that field actually a date field?  Are you looking for the most recent Bill date?
Photo of NP

NP

  • 10 Points
I'd like to pull the date from the most recent contract. Most often than not, there is usually just one contract but we do have cases when there are multiple. And yes, it is an actual date field.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
If its an actual date field you should be able to do a simple summary of the maximum  of that date field.
Mark
Photo of NP

NP

  • 10 Points
And there you have it! It worked, thank you!