AnsweredAssumed Answered

Sort dataview by Decreasing Date

Question asked by bbroughton on Jul 15, 2019
Latest reply on Jul 16, 2019 by malav

Before I go to too much trouble building in a workaround I thought I'd see if anyone in the Community has found an simple way to Sort a dataview by decreasing date.

 

Below is the issue you get in BOARD when you try to sort on the Day Entity as a block..  The issue is that it doesn't actually sort it as a 'date', but more as a text/numeric field by just sorting character by character (meaning 3rd to 9th will come before 29th).

 

Find()/Day()/Month()/Year() don't work in DV algorithms, so before I go to Nexel to reformat the date I'm wondering what other (possibly simpler) solutions people have found.

 

 

Outcomes