DATEONLY Function

From Planfix
Revision as of 13:51, 20 February 2024 by Dmitri (talk | contribs) (→‎Go To)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

The function DATEONLY takes a string with a date and a time as argument and returns only the date.

Format

DATEONLY(string)


The string corresponds to the formats:

  • DD.MM.YYYY HH.MM.SS
  • DD-MM-YYYY HH:MM
  • DD/MM/YY

Any symbols can be used as separators.

If the year is entered with two digits, it is automatically converted to a 20th century.

Examples

DATEONLY("12-03-2020 16:45:13") — Result: 12.03.2020

DATEONLY("8/3/2020T16:45:13") — Result: 08.03.2020

DATEONLY("8/3/15 16:45") — Result: 08.03.1915


Go To