Rank using a query
Hi everyone, I have a list of records that I need to rank, first by the expected start date, then by the final date required, then by the build priority, and last using the record ID. One thing t...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAn alternative would be to create a concatenated field which would combine all 4 fields and will sort correctly and then just run the Formula Query against that single field. You would need to convert the dates to strings like
20220719 (ie July 19, 2022)
You will need to control where fields with missing dates sort, at the top or the bottom. You can do that with the formula which makes the YYYYMMDD portion of the concatenated field.
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
20220719 (ie July 19, 2022)
You will need to control where fields with missing dates sort, at the top or the bottom. You can do that with the formula which makes the YYYYMMDD portion of the concatenated field.
------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------
Thank you for the suggestion Mark, I should have specified that only 3 of the 4 fields are date fields. The Build priority is a numerical ranking 1, 2, 3. I believe what you are suggesting would only work if all 4 of the fields are date fields, but perhaps I can append the build priority to the end of the date fields to still make this work. I will give that a try.
------------------------------
Emma Finger
------------------------------
------------------------------
Emma Finger
------------------------------