Type casting

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
8
9
10
11
// Milliseconds since Jan. 1, 1970
Date(1476987783555)
// returns a date representing Oct 10, 2016 14:23:03.555 PDT

// ISO 8601 text
Date('2016-10-20T17:41:37+00:00')
// returns a date representing Oct 10, 2016 13:41:37 PDT

// Converts a DateOnly value to a Date value
Date(DateOnly(2022, 1, 2));
// returns a date representing Feb 2, 2022 00:00:00 PDT

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
DateOnly(true)
// '1970-01-01'

DateOnly(Date(2016, 10, 20, 17, 41, 37, 0, "UTC"))
// '2016-11-20'

// Milliseconds since Jan. 1, 1970
DateOnly(1476987783555)
// '2016-10-20'

// ISO 8601 text
DateOnly('2016-10-20T17:41:37+00:00')
// '2016-10-20'

DateOnly(Time(17, 41, 37))
// null

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
// Number of milliseconds since Jan. 1, 1970.
Number(now())  // 1661206550823

Number(DateOnly(2022, 1, 1));  // returns 1643673600000

Number(Time(12,30,59));  // returns 45059000

// 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
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
// 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:mm:ss')  // returns 'Tuesday, October 25, 2016 @ 08:43:11'

// Format DateOnly
Text(DateOnly(2016, 9, 25), 'dddd, MMMM D, Y')  // returns 'Tuesday, October 25, 2016'

// Format time
Text(Time(14,43,11), 'h:mm:ss A')  // returns '2:43:11 AM'

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Time(true)
// '00:00:00.001'

Time(Date(2016, 10, 20, 17, 41, 37, 00, 'UTC'))
// '17:41:37'

Time(DateOnly(2020, 2, 22))
// '00:00:00'

// Milliseconds since start of the day
Time(60000)
// '00:01:00'

// One more millisecond than fits in one day
Time(86400001)
// null

Time('12:34')
// '12:34:00'