1. Date and Time Functions

The date time functions carry out calculations on the date and time values. The data type of these values is always datetime data type.

• • CALENDAR
• • CALENDARAUTO
• • DATE
• • DATEDIFF
• • DATEVALUE
• • DAY
• • EOMONTH
• • HOUR
• • MINUTE
• • MONTH
• • NOW
• • SECOND
• • TIME
• • TIMEVALUE
• • TODAY
• • WEEKDAY
• • WEEKNUM
• • YEAR
• • YEARFRAC

2. Time Intelligence Functions

The time-intelligence functions are used to evaluate values over a fixed period such as days, weeks, months, quarter, years, etc. You can specify a time period using these functions and compare two scenarios in your report.

• • CLOSINGBALANCEMONTH
• • CLOSINGBALANCEQUARTER
• • CLOSINGBALANCEYEAR
• • DATEADD
• • DATESBETWEEN
• • DATESINPERIOD
• • DATESMTD
• • DATESQTD
• • DATESYTD
• • ENDOFMONTH

3. Logical Functions

The logical functions are used to evaluate an expression or argument logically and return TRUE or FALSE if the condition is met or not.

• • AND
• • FALSE
• • IF
• • IFERROR
• • IN
• • NOT
• • OR
• • SWITCH
• • TRUE