/
FORMATDATE

FORMATDATE

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

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

FORMATDATE
FORMATDATE
Datameer X v10
More like this
FORMATDATE
FORMATDATE
Datameer X v11
More like this
ASDATE
ASDATE
Datameer X v11
More like this
ASDATE
ASDATE
Datameer X v10
More like this
ASDATE
ASDATE
Datameer v7
More like this
MSTODATE
MSTODATE
Datameer X v11
More like this