These are the docs for the Metabase master branch. Some features documented here may not yet be available in the latest release. Check out the docs for the latest version, Metabase v0.50.
Now
now
returns the current datetime using your Metabase report timezone.
Creating conditional logic using the current date or time
Let’s say you have some project data, and you want to add a status column for each task. We’ll assume today’s date and time is November 22, 2022, 12:00:00.
Task | Start | Deadline | Status |
---|---|---|---|
Draft | November 1, 2022, 12:00:00 | November 30, 2022, 12:00:00 | In progress |
Review | November 15, 2022, 12:00:00 | November 19, 2022, 12:00:00 | Needs extension |
Edit | November 22, 2022, 12:00:00 | November 22, 2022, 12:00:00 | DUE RIGHT NOW! |
To mark a task in progress, you’d use the expression:
now >= [Start] AND now < [Deadline]
To check if you need to ask for an extension:
now >= [Start] AND now >= [Deadline]
If you’re looking for an adrenaline rush (and you have real-time data), you can flag the tasks that are due right this second:
now = [Deadline]
To set up the Status column that combines all three situations above, you’d wrap everything in a case
expression:
case(now >= [Start] AND now < [Deadline], "In progress",
now >= [Start] AND now >= [Deadline], "Needs extension",
now = [Deadline], "DUE RIGHT NOW!")
Data types
Data type | Returned by now |
---|---|
String | ❌ |
Number | ❌ |
Timestamp | ✅ |
Boolean | ❌ |
JSON | ❌ |
now
returns a timestamp with time zone
if time zones are supported by your database, otherwise now
returns a timestamp without time zone
.
For more info about the way these data types behave in Metabase, see Timezones.
Limitations
now
might not actually be now (in your local time) if you don’t live in the same timezone as your Metabase report time zone.
If you need to compare now
to a column in a different time zone, use convertTimezone to shift both columns into the same time zone. For example:
convertTimezone(now, 'UTC', <report timezone>) >= convertTimezone([Deadline], 'UTC', <source time zone>)
Related functions
Different ways to do the same thing, because while you’d love to use custom expressions more, now’s just not the time.
SQL
When you run a question using the query builder, Metabase will convert your query builder settings (filters, summaries, etc.) into a SQL query, and run that query against your database to get your results.
By default, now
uses your Metabase’s report time zone. If your admin hasn’t set a report time zone, now
will use your database’s time zone.
Say you’re using a Postgres database. If your Metabase report time zone is set to EST, you’ll get now
in EST:
SELECT CURRENT_TIMESTAMP AT TIME ZONE 'EST'
If you don’t have a report time zone, you’ll get now
in the Postgres database’s time zone (typically UTC):
SELECT CURRENT_TIME
Spreadsheets
The spreadsheet function NOW()
gets the current date and time in your operating system’s time zone (the time that’s on your computer or mobile device).
Python
You can use pd.Timestamp.now()
using the pandas
module. This will give you a Timestamp
object with the current date and time in your operating system’s time zone.
Further reading
Read docs for other versions of Metabase.