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

      Hello,

      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

       

      Thanks,

      Vishi