1

I have a calculated column that calculates today date dynamically

I followed this link

problem is calculated column in number data type. I want it as Date and Time date format.

I want to calculate date difference between dynamic today date and another Overdue date field.

Can you help me please...

2

First, you should be aware of the output of the two date difference should be in Days or Months or Years as a Number!

If you set The data type returned from this formula as DateTime, it would work but it logically would show invalid data.

enter image description here

So the difference should be shown as Number Not as Date format!


To get the diff between today and overdue date through this calculated column formula

=DATEDIF([overdue date],TODAY(),"d")

enter image description here

Note:

The calculated column formula is only calculated/updated in the following cases:

  • Add New Item.
  • Update Existing item.
  • Update the calculated column itself in the List Setting!

Check Also


To update the calculated column daily

Try to Create a Retention Policy to run a workflow which updates the list items daily!!

Or instead of using calculated column, use JSlink as mentioned at Days Past Since List Item Created - SharePoint Online 2013

  • TODAY() function will calculate dynamically or static function.. – Manikandan Oct 6 '17 at 11:12
  • =IF (ISERROR(DATEDIF(TODAY(),[Renewal Date 01],"d")),"DUE",DATEDIF(TODAY(),[Renewal Date 01],"d")) – Manikandan Oct 6 '17 at 11:12
  • If it is dynamic ok for me otherwise have to update daily... – Manikandan Oct 6 '17 at 11:13
  • bro, please read my answer carefully, I mentioned The calculated column formula is only calculated/updated in the following cases: - Add New Item.- Update Existing item.-Update the calculated column itself in the List Setting! so today will get the current date when the above-mentioned actions happened ! also I have updated my answer with workarounds to calculate it dynamically !! – Mohamed El-Qassas MVP Oct 6 '17 at 11:26
  • Ok got it. I understood – Manikandan Oct 7 '17 at 5:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.