Date and time functions allow you to manipulate dates and times within Datameer X workbooks. These include seeing if a specific date is before another, showing dates as timestamps, returning only the month of a specified date, etc.

Datameer X always uses the following format:

Three character month abbreviation (space) one or 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).

The following are the date and time functions in Datameer X

Browser not supported