4 Replies Latest reply: Dec 1, 2015 4:15 AM by Marcus Sommer RSS

    Fields of Date are not sorted properly in QV model


      I have QV model which has the following fields  of Dates:


      Day(VWDATE) as Day,
      Date(floor(VWDATE)) as Date,
      Date((floor(VWDATE)), 'DD/MM/YYYY') AS DateField



      So when the model is loaded and I present each of the files in the list boxes I see that only Day field is sorted properly, whether Date sorted in descending order and DateField is not sorted at all.


      Please see print screen attached,

      I have to say that this phenomenon is new to me as in all models all Dates fields appear in ascending order without any manipulation from my side.


      Please help.