Skip to main content
Question

Most recent date formula

  • September 23, 2019
  • 0 replies
  • 27 views
Hello,

I have a table of all my invoices from various clients. I would like to create a field in a child table that will pull the most recent invoice date based off the client (the client ID# is the key field for the child table).

Thanks

------------------------------
John Bankert
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • September 23, 2019
If you have a relationship where 1 client has many Invoices, just make a Summary field on the left side of the relationship of the Maximum of the Invoice Date.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement