To calculate the power of a number

The function returns the power of a base number using the exponent. If the exponent has the value 0.5, the result is the root of the base number.

Syntax

pow(number, number)

Return

number

Examples

pow(x,y) To calculate the power of a base x using the exponent y.

pow(4,3) 

Result: 64

pow(64,0.5) 

Result: 8

pow(64,1/3) 

Result: 3.9999999999999996

To return the quarter of a given date as a number

This function will return the quarter of a given date as a number with the 1st quarter = 1, … 4th quarter = 4.

This can be helpful when filtering, sorting, and/or grouping records with a calendar reference.

If you use the function together with an appointment, make sure to specify if you need the start or the end.

Syntax

quarter(date)

Return

number

Examples

quarter(Date) 

Result: 2 (with Date = 06/02/2021 (US) and 02/06/2021(UK))

quarter(start(Appointment)) 

Result: 2 (with Appointment =

• 06/02/2021 09:00 - 07/03/2021 18:00 (US)
• 02/06/2021 09:00 - 03/07/2021 18:00 (UK))

quarter(endof(Appointment)) 

Result: 3 (with Appointment =

• 06/02/2021 09:00 - 07/03/2021 18:00 (US)
• 02/06/2021 09:00 - 03/07/2021 18:00 (UK))

See also

date which converts to or returns a date value.

day which returns the day of the month from a given date value as a number.

month which returns the month from a date value as a number.

week which returns the calendar week of a given date value.

year which returns the year of a given date value.

yearquarter which returns the quarter and the year of a given date value.