NOW() – Returns the current date and time

The NOW() function returns the current system date and time. The format of the time is based on your MathGrid time format settings, and the date will follow the date format settings.

Syntax

NOW()

This function takes no arguments.

Basic example

NOW()

Returns the current date and time.

Example outputs (depending on date and time format settings):

If current date is January 15, 2025, and time is 9:30 AM:
Time format: "12 hour format with leading zeros" → "09:30 AM"
Time format: "24 hour format without leading zeros" → "9:30"
Time format: "12 hour format without leading zeros" → "9:30 AM"
Time format: "24 hour format with leading zeros" → "09:30"

Key features

Dynamic value: The date and time are dynamic and update to reflect the current moment each time the formula is recalculated.
Format-dependent: The output format is determined by the "Time Format Settings" in MathGrid's settings panel.
Date and Time: Unlike TODAY() which only returns the date, NOW() includes the current time.

Practical uses

Timestamping when data was entered or last updated.
Creating logs with precise time information.
Displaying the current time in a document for reference.

Common mistakes

Adding arguments: The function NOW() does not accept any arguments. Using it like NOW(T1A1) will result in an error.
Expecting both date and only time: NOW() returns the current date and time. If you need only the date, use TODAY(); if you need only the time, use a time extraction formula.
Ignoring settings: The display format is controlled globally in MathGrid settings. Ensure these are configured to your needs.

Report issue