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...

1

1 Answer 1

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

6
  • TODAY() function will calculate dynamically or static function..
    – Manikandan
    Oct 6, 2017 at 11:12
  • =IF (ISERROR(DATEDIF(TODAY(),[Renewal Date 01],"d")),"DUE",DATEDIF(TODAY(),[Renewal Date 01],"d"))
    – Manikandan
    Oct 6, 2017 at 11:12
  • If it is dynamic ok for me otherwise have to update daily...
    – Manikandan
    Oct 6, 2017 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 !! Oct 6, 2017 at 11:26
  • Ok got it. I understood
    – Manikandan
    Oct 7, 2017 at 5:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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