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!
Adding upcoming dates to interface dashboard
+2This topic has been closed for replies.
+17Create 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.
+31Hm, I'm not really following sorry. May I know what the business logic is?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.