Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Format Year

Status
Not open for further replies.

BreffniK

Technical User
Apr 27, 2004
24
US
Currently, my years display as follows:

2,006.00

How may I get them to display as

2006

Thanks!
 
It appears that you're showing your year as a numeric field. If it's its own field on the report, you can right-click on it and format the number.

If you're using ToText, you can use a format parameter, something like this: ToText({year}, 0)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.
 
With totext, you would want to make the formula:

totext({table.year},0,"")

...to also remove the comma.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top