2 Replies Latest reply: Jun 28, 2017 10:40 AM by Jose Miguel Vilaplana Pascual RSS

    Month Number to Display as Name

    Linda Pembroke

      I had to change my month names to numbers in order to use them as max values in some expressions. Now I am needing them to display as 'Jan', 'Feb', etc for the list box selection but still maintain a numeric value.

       

      I have tried the Pick and Dual(Pick( functions, but they are not sorting properly even when I choose ascending by numeric value. Is there any way to preserve the numeric trait while displaying as text?