syntax:types
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
syntax:types [2017/12/23 09:44] – dmitry | syntax:types [2017/12/23 09:48] – dmitry | ||
---|---|---|---|
Line 16: | Line 16: | ||
< | < | ||
- | To convert text values to numbers see [[syntax: | + | To convert text values to numbers see the [[syntax: |
==== Dates ==== | ==== Dates ==== | ||
Line 38: | Line 38: | ||
Note: Ampersand (&) is the text concatenation operator. | Note: Ampersand (&) is the text concatenation operator. | ||
- | To convert | + | To convert |
==== Boolean ==== | ==== Boolean ==== | ||
Line 45: | Line 45: | ||
==== Error ==== | ==== Error ==== | ||
- | Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using [[syntax: | + | Error is a special value that indicates incorrect calculation. It can only be a result of an expression. You can check if a value is an error using the [[syntax: |
+ | |||
+ | You can also create an error values use the [[syntax: | ||
==== Empty values ==== | ==== Empty values ==== | ||
- | If a table cell has no value - it's so called //empty value//. You can check if a column value is empty using [[syntax: | + | If a table cell has no value - it' |
Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. | Empty values are somewhat similar to nulls in relational databases but not exactly. For instance an empty value always equals to another empty value and equals to empty string. |
syntax/types.txt · Last modified: 2021/05/12 07:33 by dmitry