8 Replies Latest reply on Jul 24, 2018 11:43 PM by viswaja sripathi

    Display String field as Date field without changing Data type

    viswaja sripathi


      I am hoping someone could help me with below issue.

      I have a requirement where I would like to use a String field which looks like date in a quick filter. But the order is messed up in the quick filter (displays alphabetical order). I would like the values to be displayed from oldest date to latest date. And the filter should always be set to current month when workbook is opened.I have attached a workbook with the filter applied. the order should be

      Jan 2017

      Feb 2017

      Mar 2017




      Dec 2017

      Jan 2018




      Jun 2018

      Jul 2018