How to calculate a 60‑Day Resolution Deadline (Record Date + 60 Days)?
I have a stakeholder who needs to create a custom date that's 60 days on from the Record Date that's in the data model.
In this scenario an event happens on March 6th and the Incident Record is created. My stakeholder needs to dynamically create a field that displays the date 60 days in the future (May 5th) by which time the Incident must be resolved.
I've tried several approaches, none of which worked.
Any help or advice would be much appreciated!
TheLivingBubba you can create this custom date on your data model.
Assuming that you have a data source, which includes the column Record Date, you can create an Add Custom Column and use the following SQL addDays([Record Date], 60). This will ensure that for every row of Record Date, you will have a field that displays the data 60 days ahead in the future.
Hope this helps.
