ActiveReports allows you to set formatting strings for date, time, currency, and other numeric values using the OutputFormat property on the textbox control. The OutputFormat dialog also allows you to select international currency values and select from various built-in string expressions. In addition to the built-in string expressions, you may use any .NET standard formatting strings.  Information about these strings (Numerics and Date/Time formats) may be found on MSDN.

Times:

• hh:mm tt = 09:00 AM
• HH:mm = 21:00 (twenty-four hour clock)
• HH = hours in 24 hour clock
• hh = hours in 12 hour clock
• mm = minutes
• ss = seconds
• tt = AM or PM

Dates:

• dddd, MMMM d, yyyy = Saturday, December 25, 1999
• dd/MM/yyyy = 25/12/1999
• d or dd = day in number format
• ddd = day in short string format (Ex. Sat for Saturday)
• dddd = day in string format (Ex. Saturday)
• MM = month in number format
• MMM = month in short string format (Ex. Dec for December)
• MMMM = month in string format (Ex. December)
• y or yy = year in two digit format (Ex. 99 for 1999)
• yyyy or yyyy = year in four digit format (Ex. 1999)

Currency and numbers:

• $00.00 = $25.50
• $#,##0.00 = $06.25
• 0 = digit or zero
• # = digit or nothing
• % = percent-multiplies the string expression by 100

Visual Basic Language Reference: Format function

 

 

---

Copyright © 2005 Data Dynamics, Ltd. All rights reserved.