Day Number substitue stopped working

[tkolman]

substitution for day number quit working with two digit day number... what am I doing wrong?

Code: Select all

[MeasureDay]
Measure=Time
Format=%#d
Substitute="1":"1st","2":"2nd","3":"3rd","4":"4th","5":"5th","6":"6th","7":"7th","8":"8th","9":"9th","10":"10th","11":"11th","12":"12th","13":"13th","14":"14th","15":"15th","16":"16th","17":"17th","18":"18th","19":"19th","20":"20th","21":"21st","22":"22nd","23":"23rd","24":"24th","25":"25th","26":"26th","27":"27th","28":"28th","29":"29th","30":"30th","31":"31st"

[Mordasius]

You are substituting the '1' in '10' with "1st". Try using Format=%d to keep the leading zero and then modifying the substitute line:

Code: Select all

[MeasureDay]
Measure=Time
Format=%d
Substitute="01":"1st","02":"2nd","03":"3rd","04":"4th","05":"5th","06":"6th","07":"7th","08":"8th","09":"9th","10":"10th","11":"11th","12":"12th","13":"13th","14":"14th","15":"15th","16":"16th","17":"17th","18":"18th","19":"19th","20":"20th","21":"21st","22":"22nd","23":"23rd","24":"24th","25":"25th","26":"26th","27":"27th","28":"28th","29":"29th","30":"30th","31":"31st"

[tkolman]

Thanks ! worked