Skip to main content
Question

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.

      This topic has been closed for replies.

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

      :) 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.






      Terms & ConditionsAccessibility statement