Notifications
Clear all
Topic starter
I'm trying to modify the Zip code to only display as 5 digits. I've been trying the truncate feature in Crystal, but am not getting anywhere. Help!
Here is what I've been trying:
Truncate({PatientProfile.Zip},5)
But it tells me that a number or currency amount is required in place of the {PatientProfile.Zip}
Thanks,
Sam
Posted : August 16, 2012 12:07 am
Truncate works with numbers or currency only. ZIP is a string.
try
Left({PatientProfile.Zip},5)
Posted : August 31, 2012 12:43 am
