Aug 09, 2024 10:16 AM
Hi, I am wondering how to display approaching deadlines based on a dates that are 1 month out and 2 weeks out to be displayed on an interface dashboard but I am unsure how to make this happen. Thanks!
Aug 09, 2024 10:27 AM
Create Formula Fields to Calculate the Deadline Ranges.
One Month Out Field: IF(AND(IS_BEFORE({Deadline Date}, DATEADD(TODAY(), 30, 'days')), IS_AFTER({Deadline Date}, TODAY())), "Within 1 Month", "")
Two Weeks Out Field: IF(AND(IS_BEFORE({Deadline Date}, DATEADD(TODAY(), 14, 'days')), IS_AFTER({Deadline Date}, TODAY())), "Within 2 Weeks", "")
By using formula fields to calculate whether deadlines fall within the next 1 month or 2 weeks, and then filtering and displaying these records in your Interface dashboard, you can effectively monitor approaching deadlines and keep track of important dates.
Aug 09, 2024 07:11 PM
Hm, I'm not really following sorry. May I know what the business logic is?