How to Use the TODAY Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics, all available without membership, so you can open the index and go directly to the task you need.

How-to Index

No.TopicMembership
11. Create a formula field and use TODAYFree
22. Check the TODAY function formatFree
33. Combine TODAY with other formulasFree

How-to Guide

1. Create a formula field and use TODAY

Entry point: Add Field → Formula

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

Success Criteria

  • Interface result: The new formula field shows the current date.
  • What you can do next: You can continue naming the field, formatting it, or using it in other formulas.

Tips While Using

  • Common mistake: Do not add extra arguments to TODAY().
  • Environment note: You need permission to edit fields in the current multidimensional table.

2. Check the TODAY function format

Entry point: Formula Editor → Function Library

  1. Open the formula editor in the multidimensional table.
  2. Go to the function library or function help area.
  3. Find the TODAY function.
  4. Confirm that the standard syntax is TODAY().
  5. Enter the function in that format in your formula field.

Success Criteria

  • Interface result: The function help shows the TODAY name and syntax.
  • What you can do next: You can continue editing and save the formula in the standard format.

Tips While Using

  • Common mistake: Do not type bracketed examples or explanatory text into the formula itself.

3. Combine TODAY with other formulas

Entry point: Formula Field → Formula Editor

  1. Open an existing formula field or create a new one.
  2. Enter a formula that includes TODAY().
  3. Add conditional logic or other date functions as needed.
  4. Save the formula and review the returned result.
  5. Adjust the field format or logic if needed.

Success Criteria

  • Interface result: The formula field returns a result based on the current date.
  • What you can do next: You can reuse the same logic in other records or fields.

Tips While Using

  • Common mistake: Check that the fields used in the formula have compatible data types before combining them.
  • Environment note: Date comparisons and calculations require fields that can participate in formula operations.