Forum Discussion
KippKipp
7 years agoQrew Cadet
Hi Matthew, your explanation is very clear.
I'd like to achieve the same thing but I can't rely on the record ID# as the identifier for the latest record, instead I need to reference a date field. I need QB to determine which is the maximum child record based on the date in the date field and return the record ID# of that record with the most recent date. I have managed to create a summary field that returns the date of the record that has the latest date but am as yet unable to translate that in to a record ID#.
The reason for this is that we are back-filling data so we can't rely on the highest record ID# being the most recent value.
I'd like to achieve the same thing but I can't rely on the record ID# as the identifier for the latest record, instead I need to reference a date field. I need QB to determine which is the maximum child record based on the date in the date field and return the record ID# of that record with the most recent date. I have managed to create a summary field that returns the date of the record that has the latest date but am as yet unable to translate that in to a record ID#.
The reason for this is that we are back-filling data so we can't rely on the highest record ID# being the most recent value.