How to Use the NOW Function in WPS on Windows

Last updated:July 23, 2026

Use the NOW function with 3 how-to topics, including creating a formula field, entering the NOW formula, and combining it with other formulas; 3 items are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call NOWFree
22. Check the NOW syntax and returned resultFree
33. Combine NOW with other formulasFree

How-to Guide

1. Create a formula field and call NOW

Entry: Add Field → Formula

  1. Open the multi-dimensional table that you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter NOW() in the formula editor.
  5. Click Confirm or save the field to view the result.

Success Criteria

  • Interface result: A new formula field appears and shows a date and time value.
  • Next action: You can continue editing the formula or adjusting the field format.

Tips While Using

  • Common mistake: Typing the function name as plain text instead of a formula expression.
  • Environment note: You need permission to edit the current table structure.

2. Check the NOW syntax and returned result

Entry: Formula Editor → Function input area

  1. Open an existing formula field for editing.
  2. Enter NOW().
  3. Confirm the function and save it.
  4. Check the returned current date and time value.
  5. Reopen the table or trigger recalculation to see whether the result changes.

Success Criteria

  • Interface result: The field shows the current date and time.
  • Next action: You can continue setting the display format or use the result in other formulas.

Tips While Using

  • Common mistake: Writing NOW with unnecessary arguments.
  • Environment note: Result updates depend on recalculation or refresh.

3. Combine NOW with other formulas

Entry: Formula Editor → Combined formula input

  1. Create or edit a formula field.
  2. Enter NOW() first as the current time source.
  3. Combine it with other functions as needed, such as date comparison or conditional logic.
  4. Save the formula and review the result for each record.
  5. Adjust the formula logic based on the result.

Success Criteria

  • Interface result: The field displays results based on your formula logic.
  • Next action: You can continue nesting more functions for more complex rules.

Tips While Using

  • Common mistake: Missing parentheses when combining formulas.
  • Environment note: For complex formulas, test the result in smaller steps first.