Forum Discussion
MarkShnier__You
4 years agoQrew Legend
no 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
------------------------------
- AshleyGwozdz4 years agoQrew MemberThanks so much Mark!
I am getting an error on this code. Is there something missing?
"Expecting text but found date"
------------------------------
Ashley Gwozdz
------------------------------- MarkShnier__You4 years agoQrew LegendThis would be a date so change the field type to be formula date.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- AshleyGwozdz4 years agoQrew MemberOh, I've got it working now. Thanks Mark!!
------------------------------
Ashley Gwozdz
------------------------------