I’m configuring the “fields to order records by” field to apply a sort order on a date. However, on the field I am sorting, most of the time it is blank. When I view the table, the blank fields are sorted before the fields with a date. I’d like to sort it so the dates are at the top of the table.
I believe I read somewhere in the community that there is a way to sort NULL values to the bottom, but I can’t seem to find that post using search.
Anyone know what I should enter into the “fields to order records by” field?
Thanks,
Andrew
Page 1 / 1
You can put NULLS LAST to make them come in at the bottom.
That’s it! Thanks so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.