MicroStrategy ONE
Date
Returns only the date portion of the date-time column. The time is truncated, not rounded.
Syntax
Date(Date/Time)
Where
Date/Time is the input date or timestamp.
For information on the syntax used in your specific database, refer to the Functions Reference.
Example
Date('2024-07-29') = 2024-07-29
Date('2024-07-29 02:00:00') = 2024-07-29