AnsweredAssumed Answered

leading 0 for month in Date function?

Question asked by user19036 on Jun 23, 2013
Latest reply on Jul 14, 2017 by makerbert



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.