How Do I Put Empty Date/Time Records at the BOTTOM of a 1-9 Sort?

[Jason_Eskin]

I have a grid view that is sorted by date 1-9, meaning it sorts rows from closest date to furthest date. This grid view of mine also has rows which have no dates set (yet) and I’d like to keep those in there BUT, I want those rows to go at the bottom of the sorted list. Right now, the only way to put them at the bottom is to sort 9-1… but then that puts the latest dated rows at the top. Any way to put non-dated rows at the bottom, but keep the 1-9 sort?

[kuovonne]

You can create a new formula field that outputs the post date if there is one and a date far into the future if there is no post date. Then sort on the formula field.

IF(
  {Posting Date & Time},
  {Posting Date & Time},
  DATETIME_PARSE("2050-01-01", "YYYY-MM-DD")
)

Filtering out the records with no post date so that you don’t see them at all might be another option.