1 2 Previous Next 18 Replies Latest reply on Jul 14, 2017 12:38 PM by makerbert

    leading 0 for month in Date function?

    user19036

      Hi,

       

      In FMP12 on a mac, How do I get a leading 0 for the single digit months in a calculation with text or number result.

       

      The records are Timestamped transactions. I created a field that converts the timestamp to a year and a month with a date function, so that I can group them according to month. But I want a result, that when I sort on it, will give me a chronological sort.

       

      Thanks,

      D

        1 2 Previous Next