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