Skip to main content
Question

Sorting a date range as string

  • February 21, 2024
  • 0 replies
  • 129 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

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
------------------------------