MicroStrategy ONE
YearStartDate
Returns the date of the first day of the year in which a date or timestamp occurs.
Syntax
YearStartDate(
Date
/
Time
)
Where:
Date
/
Time
is the input date or timestamp.
For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions.
Examples
Input is the date 2004-07-29
; output is the date 2004-01-01
.