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

    leading 0 for month in Date function?




      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.




        1 2 Previous Next