* '''And (&&)''': Performs the logical operation ''AND'' between two boolean values. The two operands must be ''true'' for the result of the operation to be ''true''. Represented by the '''AND''' operator (&&). The expression syntax is ''<expression> && <expression>''. Examples: IF((Gross Sales > '0') && (Seller == 'John Snow');'Sold';'Not Sold'), IF((City!="#null") && (Date<DAY_FROM_TODAY(0));1;0);

* '''Or (||)''': Performs the logical operation ''OR'' between two boolean values. One of the two operands must be ''true'' for the result of the operation to be ''true''. Represented by the '''OR''' operator (||). The expression syntax is ''<expression> || <expression>''. Examples: IF((Gross Sales > '0') || (Sold == 'true');'Sold';'Not Sold'), IF((City!="#null") || (Date<DAY_FROM_TODAY(0));1;0);

* '''Not (!)''': Performs the denial logical operation for a boolean value. If the operand are ''true'' the ''NOT'' convert it to ''false'' (and the other way around). Represented by the '''NOT''' operator (!). The expression syntax is ''! <expression>''. Examples: IF(!BETWEEN("Date", '01/01/2013', '31/12/2013');'Not 2013';'2013').

As funções de data são operações que tomam como base parâmetros ou resultado do tipo The date functions are operations that use as parameters and return result of the [[Date|date datatype]].

* '''Date partfunctions constants list:''': Retorna uma parte de uma data. Sintaxe** '''0''': DATE_PARTDATE_FIELD_YEAR (<expressão_data>Year part);<expressão_const_parte>** '''1''': DATE_FIELD_MONTH (Month part); Exatamente dois parâmetros, sendo que o primeiro é da data de referência e o segundo parte de interesse. Note que a parte deve ser uma das constantes numéricos definidas acima** '''2''': 0, 1, 2, DATE_FIELD_DAY (Day part);** '''3 ou ''': DATE_FIELD_FORTNIGHT (Fortnight part);** '''5. Exemplo''': DATE_PARTDATE_FIELD_WEEK ("Data"Week part);0) - retorna o ano da coluna "Data" da linha atual da tabela.

* '''First day ofDate part''' Retorna o primeiro dia de um agrupamento: Return a part of a date. SintaxeSyntax: FIRST_DAY_OF''DATE_PART(<expressão_const_parte_agrupamentoexpression_date>;<expressão_data_baseconstant>) ou FIRST_DAY_OF''. Need two parameters, the first is the reference date and the second the constant representing the desired part date: 0, 1, 2, 3 or 5 (see above constants list). Examples: DATE_PART("Order Date";0) - returns the year part of the "Order Date"; * '''Day from today''': Return a backward (negative) or forward (positive) date counting from today. Syntax: ''DAY_FROM_TODAY(<expressão_const_parte_agrupamentoexpression_number_days>)''. Need one parameter, the number of days to add or subtract. Examples: DAY_FROM_TODAY(-1) - returns the yesterday date; * '''First day of''': Return the first day of a grouping. This function have two variations:** '''First''': Syntax: ''FIRST_DAY_OF(<expressão_campo_mod_data_baseconstant>;<expressão_valor_mod_data_baseexpression_date>)''. Duas variações de parâmetros (2 ou 3):