Forum Discussion

TimD's avatar
TimD
Qrew Trainee
4 months ago

Sorting a date range as string

Hello,

I have a summary report where depending on their completion date will get grouped together by the work week they're supposed to be in but im having issues trying to sort them properly since the days are text.

They show up like this. I would very much like these sorted from oldest to newest. Any ideas? The choices for the custom sorting didnt really give me a lot



------------------------------
Tim D
------------------------------

5 Replies

  • you will need to create a new formula text field to identify the week in the format 

    YYYY-MM-DD to YYYY-MM-DD



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • TimD's avatar
      TimD
      Qrew Trainee

      Mark, I dont seem to be following.

      How will that fix the sorting issue? Wouldn't that still run into the same issue?



      ------------------------------
      Tim D
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        I believe that your field for "week" is actually a formula text field type.  Is that right?

        So the report is just an alpha sort.

        If it is a text formula field then if you post your formula that I can help you rewrite it into a way that would sort alpha correctly.  



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------