Show blank fields last in table sort order

Questions
,
1

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

2

You can put NULLS LAST  to make them come in at the bottom.

3

That’s it! Thanks so much!