Skip to main content
Question

Date and Time Field from Child to Parent

  • July 20, 2021
  • 0 replies
  • 62 views
Hi,

I am trying to get a date and time field from a child to a parent. I tried Maximum value, but it is not doing what I need it to do. Essentially I need the date and time field to be used as a filter for data that I have brought over to the parent table from the child table. 

Ex. team members work a project. I need to summarize the # of project per team member for a specific period of time. but I would like to pick the time frame in the parent table.

Is this possible?

thank you in advance.​

------------------------------
Zana S
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
It's not so clear from the question, but I will assume that 
One Team member Has Many Projects.

You want to enter a date range on the Team Member table (ie two fields called [Analysis Star] and [Analysis End] and you want to know how may projects they worked on during that period.

Is that the question? if so, do the child projects record have a start and stop date on them?

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