DeveloperBarn

Rebelle · #1 April 29th, 2008, 03:59 PM

Hey All,

I have a currency field in SQL 2000 - money(8) in my table with value ex: 117000 and in ASP, I have the following:

Code:

<TD bgcolor="#E0FFFF" align=center><%=formatcurrency(rs("ItemCost"),0)%></TD>

It displays as $117,000 on the web view, but I don't want it to show this, I want it to show $117 only.

Is this possible?

Thanks!

Wolffy · #2 April 29th, 2008, 04:56 PM

Divide it by 1000 first and take the integer of the result.

Rebelle · #3 April 29th, 2008, 10:32 PM

Thanks Wolffy!
Here is what I did and it looks good, like $117.

Code:

<%
intItemCost = rs("ItemCost")
intItem = FormatCurrency((intItemCost / 1000),0)
%>

Code:

<TD bgcolor="#E0FFFF" align=center><%= intItem %></TD>

Thanks so much!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

format currency to display by thousands

The Following 2 Users Say Thank You to Wolffy For This Useful Post:
jmurrayhead (May 27th, 2008), Rebelle (June 17th, 2008)