DATEONLY Function

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

• Standard operators and Planfix functions
• Calculated fields
• Reports