The SharePoint Today function will return the number of elapsed days since a reference date, in this case, December 31, 1899 (serial number 1). These are called “token numbers” and are stored in this way to facilitate calculation. The SharePoint Today function will only return the date, so if you want to get the time you need to use the Now function.

Usage

Usually, this value is used behind the scenes without us noticing. SharePoint adds to the List the “Created” column automatically that uses the Today function as the default value.

We also use it when we create a column and select the “Today’s Date ” as the default value.

You’ll only use this function when you need to perform calculations from the current date, by creating a calculated field, for example.

Limitations

Although the reference indicates that we cannot use it in calculated fields, we can include it and get something. We’ll get the token and not a date. You can quickly test this by creating a calculated field:

=TODAY()

You can see the token for Today’s date.

If you want to get the actual date, then you need to convert the token by adding it to the reference date, but this would be quite cumbersome with no real added value. Use it as a default value, and SharePoint will do the work for you.

Recommendations:

  1. Use this field only as a default value or to calculate differences in dates. See DateDif for some examples on how to use it in a formula.
  2. Don’t use the Today function if you want to do time-sensitive operations. Today will only contain the date, so you need to use the Now function to get the time.

Sources:

Microsoft’s Today Function Reference

Introduction to SharePoint formulas and functions

 

Back to the SharePoint’s list formula reference.

Featured Image by Kari Shea on Unsplash

Manuel Gomes

I'm a previous Project Manager, and Developer now focused on delivering quality articles and projects here on the site. I've worked in the past for companies like Bayer, Sybase (now SAP), and Pestana Hotel Group and using that knowledge to help you automate your daily tasks

View all posts by Manuel Gomes →

Leave a Reply

Your email address will not be published. Required fields are marked *