Forum Discussion

TheLivingBubba's avatar
TheLivingBubba
Cloud Apps
03-06-2026
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...
Date Functions
formulas
  • MikeGre's avatar
    MikeGre
    03-07-2026

    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.

     

MikeGre's avatar
MikeGre
ETL
03-07-2026

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.