RPV Reports / Home
 
Search in RpvSoftware.com
Go!

What Rpv is

Rpv Reports 2024

Downloads

Support

Buy now!

Contact us

 
Rpv Reports help>

Format command
Use the Format command to format numbers, dates and times.

Syntax:

Format=[format]
Example: {Format=###,##0} 1234 {Format=;\n}

Will be shown: 1,234 {format=currency} 1234 {Format=;\n}

Will be shown: $ 1,234.00

To close the format it will be necessary to close it with this command: {Format=}

More examples:

Expression

Format

Result

1234

currency

$ 1,234.00

12

#,##0.00

12.00

12

0000.00

0012.00

7890

#, K

7 K

7890123

#, K

7890 K

7890123

#,, M

8 M

01/01/2014

dd/MM/yyyy

01/01/2014

05/01/2014

dd/MMM/yyyy

01/May/2014

01/05/2014

dd/MMMM/yyyy

05/January/2014

2/19

MMMM

February


Depending on the regional settings on your computer, the format may vary.  In some countries for example, thousand separator is period instead comma. However, the format must be always speficied with comma as thousand separator. Windows, according the regional settings of the system will show the appropiate format. The same will occur with the currency and date formats.

Home
What Rpv is
Rpv Reports 2024

Products
Rpv Reports 2024
Personalized edition

More...
Downloads
Support
Rpv Reports Online help
Rpv Visual Editor online help
Examples
/temp section
Videos




Copyright (c) 2001-2024 - Rpv Software. All rights reserved.