In regards to the calculation between two record

[RockRsv]

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. 

[GlideFather]

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

[RockRsv]

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 

[RockRsv]

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

[GlideFather]

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

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