/
FORMATDATE

FORMATDATE

Owned by Juliane Wetzel
Last updated: May 09, 2023

Syntax

FORMATDATE(<date>;<string>)

Description

Converts dates to strings by applying a date and time parse pattern.

Examples

Column1

Pattern

FORMATDATE returns

19 Sep, 2008 11:13:27

dd-MM-yyyy hh:mm:ss

19-09-2008 11:13:27

25 Sep, 2005 12:23:05 PM

dd.MM.yyyy hh:mm:ss

25.09.05 12:23:05

15 Oct, 2002 10:35:08

dd-MM-yyyy

15-10-2002

25 Nov, 2010 11:56:13

yyyy-MM-dd

2010-11-25



Related content

Date and Time Parse Patterns
Date and Time Parse Patterns
Datameer X v11
Read with this
FORMATDATE
FORMATDATE
Datameer X v10
More like this
FORMATDATE
FORMATDATE
Datameer v7
More like this
ASDATE
ASDATE
Datameer X v10
More like this
ASDATE
ASDATE
Datameer X v11
More like this
ASDATE
ASDATE
Datameer v7
More like this