In regards to the calculation between two record

RockRsv
Tera Contributor

I need a calculation between two records in my app engine. I am currently working in dev environment - sandbox and needed to get a column which gives the difference between two fields.

as a example:
 

column 1: due date - 08/31/2025
column 2: lead time - 30

output : start date: 08/31/2025 -30 = 07/31/2025

and i want to use this a trigger daily on flows. How i can get this difference in my instance. I tried using formula but not working. my instance is currently not allowing me to script anything. can anybody let me know the logic can be used?

 

Thanks in advance. 

7 REPLIES 7

GlideFather
Tera Patron

Hi @RockRsv 

8/31/2025 - 30 = 8/01/2025 😉 

 

you can create a new field and calculate it into it. Will it be always 30 or it may vary?

 

if always 30, you can set a default value to the field to be always -30 or it can be onChange client script or a business rule.. please provide more details

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Thanks for the correction. It can vary. so i need to get automatically based on date date - lead time to get a date in the filed and schedule the trigger. @GlideFather 

@GlideFather  - I tried using the business rule in the properties but couldn't achieve the result. like subtract {due date - lead time}.

@RockRsv Please share an error message, logs or screenshots..

 

what does “i couldnt achieve” mean? Was the br triggered? 

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */