When using NOW, the most common questions are about syntax, refresh behavior, and combined formulas; this FAQ includes 3 frequent questions and a short glossary.
FAQ
Why does NOW not return the result I expect?
- Make sure the current field type is Formula, not text or another field type.
- Check whether the function is written as
NOW(). - Save the field and confirm that the date and time result has been calculated.
Why does the NOW result change?
- NOW returns the current date and time.
- When the table recalculates, refreshes, or reopens, the result may update.
- If you need a fixed timestamp, save the value into a regular field for later use.
How to use the NOW function in WPS for date and time checks?
- Enter
NOW()in a formula field to get the current date and time. - Compare that result with your target date field.
- Nest it inside formulas such as IF when you need status text or conditional output.
Glossary
| Term | Definition |
|---|---|
| NOW | A function that returns the current date and time. |
| Formula field | A field type in a multi-dimensional table that calculates results automatically with a formula. |
| Recalculation | The process of running formulas again after a refresh, edit, or reopen action. |