ExcelConverter

Syntax

ExcelConverter(<integer>)

Description

Converts integer dates from Excel to a date.

Examples

Excel formula	Excel result	ExcelConverter returns
=DATEVALUE("2011-08-22“)	40777	Aug 22, 2011 12:00:00 AM
=DATEVALUE("2011/02/23“)	40597	Feb 23, 2011 12:00:00 AM
=DATEVALUE("5-JUL")	42190	Jul 5, 2015 12:00:00 AM

Datameer always uses the following format:

Three character month abbreviation (space) two digit day (comma)(space) four digit year (space) two digit hour (colon) two digit minute (colon) two digit second (space) two character meridiem notation.

(e.g., 12.01.2012 gets transferred to Jan 12, 2012 12:00:00 AM)

When selecting a pattern, you select the way the data gets parsed (your input format, this can be connected to your systems representation of dates and times).

Datameer v7

ExcelConverter

Analytics

Syntax

Description

Examples

Related content