formatting 1

[Newbi1]

I have several fields I am trying to format in formulas. The problem is when i convert them to text, the formatting keeps changing from what I want.

Cstr(int(year(currentdate)))+ "AYP Status"

How do i remove the columns and decimals within the formula? I have tried changing the global settings, but the when it is run on another persons version of crystal, it is goofed up again.

 

[Madawc]

You can control data format using commands like Totext({your.date}, "dd MMM yyyy") etc.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems.

Madawc Williams (East Anglia, UK)

 

[mbarron]

This will do the trick.
Cstr(int(year(currentdate)),0,"")+ "AYP Status"

Mike

 

[Newbi1]

thanks Mike.

Sorry madawc. Seems like every day i am on a different version of CR. I will specify in the future