How bring dates through a relationship from child to parent table

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
  • (Edited)
I have a child table with a field of dates, I want to bring these dates through to the parent table. There is only one date for each project so basically just want to replicate the dates on the child table on to the parent table.
I have tried doing a summary of the field how ever it says I cannot which I assume is because it is dates.
How can I do this?
Photo of Max Williams

Max Williams

  • 142 Points 100 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
If you are looking for a summary like a maximum or minimum, then that should work easily.
If you ar looking to have a Combined Text Summary field of all the unique, then you will need to first make a new field to convert the date to a text field.

For example

ToText([my date field])

Then do the Combined text summary on that text field. Combined text summary fields can only combine text fields.