DATEONLY Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=DATEONLY Function |titlemode=append |keywords=planfix, reports, functions |description=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 automa...") |
(→Go To) |
||
| Line 35: | Line 35: | ||
== Go To == | == Go To == | ||
*[[ | *[[Standard functions | Standard operators and Planfix functions]] | ||
*[[Calculated fields]] | *[[Calculated fields]] | ||
*[[Reports]] | *[[Reports]] | ||
Latest revision as of 13:51, 20 February 2024
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