The first category of time intelligence functions that we are going to look at are those that return a single value. In reality, they return a single row of a single column table, so they can be used with any function that requires a table as a parameter.
The functions in this category are as follows:
- FIRSTDATE and LASTDATE
- FIRSTNONBLANK and LASTNONBLANK
- STARTOFMONTH and ENDOFMONTH
- STARTOFQUARTER and ENDOFQUARTER
- STARTOFYEAR and ENDOFYEAR
Let's look at the first of these functions to help us understand how the functions in this category work.
The syntax of the FIRSTDATE function is as follows:
FIRSTDATE ( <Dates> )
The syntax of the LASTDATE functions is as follows:
LASTDATE ( <Dates> )
These functions ...
