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

    Fields of Date are not sorted properly in QV model

    Inna Shnaiderman

      Hi,

      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.