This content has been marked as final. Show 2 replies
Try this :
Create a Workflow and use the below expression on the field you want to update
30 is the number of days in a month, this is a simple approach. If you want to use the actual number of months (which I think is your requirement) from that start date to the end date based on the number of months selected in Term Length, you will have to so some more If's and else, use the IIf function to validate this.
Ex: IIf(Month value of Start date is 1/January and the number of months selected in term length is 5 then you will have to build your logic around that to get number of months in each of those 5 months and use the sum of that in the code above.
Thanks for the reply with the 2 solutions.
I thought of multiplying months*30, but is that how oracle treats the default month calculations in the system (if any).
Wouldn't it show a discrepancy in the report where I can use TIMESTAMPADD(SQL_TSI_MONTH, no. of months, start date).
Will your formula and this report show the same dates? (Will try and update the answer)
2nd solution might work but we are supposed to have a limit of 84 months in that field and using the IIF condition, does the workflow allow for that many conditions (without or with breaking it up into many workflows)
will try to see if the 1st option works.