The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format set in the operating system is used.
Example:
The examples below assume the two following operating system settings:
| Default setting 1 | Default setting 2 |
Number format | # ##0,# | #,##0.# |
num( A, '0.0' ) where A=35648.375 returns:
| Setting 1 | Setting 2 |
String | 35 648 375 | 35648.375 |
Number | 35648375 | 35648.375 |
num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:
| Setting 1 | Setting 2 |
String | 35,648.00 | 35,648.00 |
Number | 35648 | 35648 |
The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the default number format set by script variables or in the operating system is used.
Examples:
The examples below assume the two following operating system settings:
| Default setting 1 | Default setting 2 |
Number format | # ##0,# | #,##0.# |
num#( A, '#' ) where A=35,648.375 returns:
| Setting 1 | Setting 2 |
String | 35,648.375 | 35648.375 |
Number | - | 35648.375 |
num#( A, '#.#', '.' , ',') where A=35,648.375 returns:
| Setting 1 | Setting 2 |
String | 35,648.375 | 35,648.375 |
Number | 35648.375 | 35648.375 |
The date function formats the expression as a date according to the string given as format-code. If the format code is omitted, the date format set in the operating system is used.
The date# function evaluates the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used.
example--
date(date#(Month,'MMM'),'MMM')as Monthes;
here date#() function tells the format of your datefield.
and date() function tells the in which format you want the datefield.
