Forum Discussion

SystemAdmin7's avatar
SystemAdmin7
Qrew Cadet
6 years ago

Formula Rich Text Field Sorting by Date

 I would like to show data based on the date it was submitted. Here's the goal a
It looks like it's sorting OK by the date, but not by the time. 

Here's the formula for the rich text field

I need it to sort by both date and time created in order to have the newest appear on top.

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    It's almost impossible to read a screen shot to read a formula so I can't really see your formula, but if you are asking how to sort a report on the [Date Created] I suggest that you simply sort the report on the [Date Created] and not that field in your screen shot.
  • SystemAdmin7's avatar
    SystemAdmin7
    Qrew Cadet
    6 years ago
    Interesting. You're not able to click the image to expand to full screen? Looks like it works for me.

    It's actually in a rich text field because it's being pulled in to a formatted report in another table. So unfortunately just sorting by date created, while an easy answer, won't work.

    • AustinK's avatar
      AustinK
      Qrew Commander
      6 years ago
      I always right clicked and opened in a new tab which is useless. This forum does not give you any indication that you can click the actual picture. Usually the pointer would change. Thanks for the tip though.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    :) OK so I never knew you could click to expand the image.

    The ideal situation would be to pull in the date created as a separate field.  Plan B if that is possible is to write a formula to parse out the [Date Created] from that field and turn it into a real date / time field. 

    Contact me directly if you want help with that as I don't have a formula handy for that.