How to get date that is 21 days from today

samadam
Kilo Sage

I am trying to create an incident if the retirement date on a case is 21 days from today. What is the best way to do it? 

1 REPLY 1

jonsan09
Giga Sage
Giga Sage

You could create a flow that runs daily or hourly (based on your business needs). The flow would look up records on your "Case" table for those retirement records that are 21 days from today. Then run a for each loop and create an incident record for each "case" that matches the filter. Here is a screen of how you could filter for 21 days from today. 

Screenshot 2025-06-12 133033.png