Sorting by date with empty dates
The current sort for my report is by date, newest to oldest, and grouped by day. The default seems to be that if the date field is empty, this record shows at the very bottom of the report. Is...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendno problem,
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
The field that you display on the report does not need to be the same field that you sort on. So just create a new formula date field called [Date Sort] with a formula of
IF(IsNull([My Date Field]), Date(2099,01,01), [My Date Field])
That will sort blanks as the most most current.
IF(IsNull([My Date Field]), Date(2099,01,01), [My Date Field])
That will sort blanks as the most most current.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Thanks so much Mark!
I am getting an error on this code. Is there something missing?
"Expecting text but found date"
------------------------------
Ashley Gwozdz
------------------------------
I am getting an error on this code. Is there something missing?
"Expecting text but found date"
------------------------------
Ashley Gwozdz
------------------------------
- MarkShnier__YouThis would be a date so change the field type to be formula date.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Oh, I've got it working now. Thanks Mark!!
------------------------------
Ashley Gwozdz
------------------------------