NOW
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Loading data...
Syntax
NOW()
Description
Returns the current date and time when the workbook is run.
Examples
| Current time when job is run | NOW returns |
|---|---|
| Fri 20 May 11:16 | May 20, 2016 11:06:03 AM |
| Wed 8 June 14:24 | Jun 8, 2016 02:24:43 PM |
Datameer X 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).