DATEONLY Function

Used in a Date column to extract the date portion of a date/time value.
Sample Usage
DATEONLY([Due Date]5)
Syntax
DATEONLY(
  • date_time
)
  • date_time
    —
    Reference to the date/time cell that contains the value from which you want to extract the date.
Usage Notes
  • Currently only values in Date/Time columns in dependency-enabled project sheets and System columns include a time component. For more information, see the Column Types article.
Was this article helpful?
YesNo