Constants

You can use constants to include specific fixed dates and times in workbooks and reports.

Constant	Example	Description	Syntax
DATE	DATE '2026-04-09'	Creates a specific date in a calculation or expression.	DATE 'yyyy-mm-dd'
TIME	TIME '12:00:00'	Creates a specific time in a calculation or expression.	TIME 'hh:mi:ss'
TIMESTAMP	TIMESTAMP '2026-04-09 12:00:00'	Creates a specific time-stamp in a calculation or expression.	TIMESTAMP 'yyyy-mm-dd hh:mi:ss'