CRD
This forum is for the sole use of CRD users. ChristianSteven Software will not accept any responsibility for the contents.
If you are converting a number to text, then you need to use a different formula which specifies what the number format is and how many decimal places you want. ToText(1001) = 1,001.00 ToText(1001,0) = 1,001 ToText(1001,0,"") = 1001 e.g. Create two formulas, one for Month and the other for Year For Year: ToText(Year({@DateConv}),0,"") For Month: ToText(Month({@DateConv}),0,"") I hope this helps