Type casting

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
// Number of milliseconds since Jan. 1, 1970.
Number(now())  // returns 1661206550823

// Parses a number using a grouping separator based on the locale
Number('1,365', ',###') // returns 1365

// Removes text from number
Number('abc10def', 'abc##def') // returns 10

// Specifies minimum digits past 0 as two and maximum digits past 0 as 4
Number('10.456','00.00##') // returns 10.456

// Specifies minimum digits past 0 as two and maximum digits past 0 as 4.
// The left and right side of the function must match or NaN is returned.
Number('10.4','00.00##') // returns NaN

// Indicates the size of the repeated group and the final group size of the input value
Number('12,12,456', ',##,###') // returns 1212456

// If there is a negative sub-pattern, it serves only to specify the negative prefix and suffix.
Number('-12,23,345', ',##,###;-,##,###') // returns -1223345

// Divide by 100. Maximum of three decimal places can be input.
Number('99.99%', '#.##%') // 0.9999

1
2
3
4
5
6
7
8
9
10
11
Boolean('true')
// returns true

Boolean(0)
// returns false

Boolean(1)
// returns true

Boolean('hello')
// returns false

1
2
3
4
5
6
7
// Milliseconds since Jan. 1, 1970
Date(1476987783555)
// 'Thu Oct 20 2016 11:23:03 GMT-0700 (PDT)'

// ISO 8601 text
Date('2016-10-20T17:41:37+00:00')
// 'Thu Oct 20 2016 10:41:37 GMT-0700 (PDT)'

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
// Pad the number to the left of the decimal
Text(123, '0000') // returns '0123'

// Restrict the number to the left of the decimal
Text(123, '00') // returns '23'

// Group the number by thousands
Text(1234, '#,###') // returns '1,234'

// Round the number to two decimal places
Text(12345678.123, '#,###.00') // returns '12,345,678.12'

// Format number as currency
Text(1234.55, '$#,###.00') // returns '$1,234.55'

// Round the number to two decimal places
Text(1.236, '#.00') // returns '1.24'

// Maintain significant digits and group by thousands
Text(1234.5678, '#,##0.00#') // returns '1,234.568'

// Format the number and format positive/negative
// if there is a negative sub-pattern, it serves only to specify the negative prefix and suffix
Text(-2, 'Floor #;Basement #') // returns 'Basement 2'
Text(2, 'Floor #;Basement #') // returns 'Floor 2'

// Multiply by 100 and format as percentage
Text(0.3, '#%') // returns '30%'

// Format date and time at the moment
Text(Now(), 'dddd, MMMM D, Y @ h:m:s')  // returns 'Tuesday, October 25, 2016 @ 08:43:11'