MelissaFreel
2 years agoQrew Member
create an order of earlies to latest dates from a summary field
Hi all:
I have a child table that has many related records to its parent. I transformed that date created field to a text field and then made a SUMMARY field in the parent table so that I could "see all the dates" of all the related records.
The challenge with this is that I would like to then manipulate this summary field back into a date/numeric field that lists the dates from earliest to latest.
I then want to "extract" different dates to do some formula work in the parent table.
So, I have the summary field (its a text field)
I want to convert it back to some kind of "numeric" or date field that then lists the dates from earliest to most recent.
I know this is a simple thing and I probably have done something in the past, but just have a quickbase mental block on solving this one.
Thanks for any help
------------------------------
Melissa Freel
------------------------------
I have a child table that has many related records to its parent. I transformed that date created field to a text field and then made a SUMMARY field in the parent table so that I could "see all the dates" of all the related records.
The challenge with this is that I would like to then manipulate this summary field back into a date/numeric field that lists the dates from earliest to latest.
I then want to "extract" different dates to do some formula work in the parent table.
So, I have the summary field (its a text field)
I want to convert it back to some kind of "numeric" or date field that then lists the dates from earliest to most recent.
I know this is a simple thing and I probably have done something in the past, but just have a quickbase mental block on solving this one.
Thanks for any help
------------------------------
Melissa Freel
------------------------------