How to use [Today] field in the calculated column

Requirement: There was a requirement to perform some calculation in the calculated column, and to achieve that we wanted to use [Today] in built column like we use it in the filter under Modify view.

But realized that, we cannot use [Today] and [Me] fields in calculated column, it will throw below error

Calculated Col

There is workaround to use [Today] field in the calculated column.

Solution (Workaround) : [Today] and [Me] are in built SharePoint columns.

  1. Now create a custom column with the same name “Today” as shown below.

Calculated Col1.png

2. Create a calculated column using custom column “Today” as shown below.

Calculated Col2.png

After creating both the columns, Today column and Calculated column will look as shown below.

Calculated Col3.png

3. Now, go back to the list Settings and delete “Today” column. and come back to the list and value in Calculated column would show Today’s date [3/3/2016] as shown.

Calculated Col4

And this is how we used [Today] column in Calculated column to store Today’s date.

Enjoy exploring…

Shree

 

 

3 thoughts on “How to use [Today] field in the calculated column

  1. Pingback: SharePoint – Filter view by Current month | Learn with Shreedevi...

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s