1934 comes after 1953

[wireshop]

Ok trying to print a layout but whenever I sort the records it always puts for example: 1934-1935 After 1953. I know technically why this happens but how do I fix it.

[comment]

Make the field type Text?

[wireshop]

oh yes of course. the calculation result was set as number }:(

Edited April 4, 2008 by Guest