How do I create a Formula Field that Compares the Output of two Date Fields?

Forum|Forum|2 years ago
December 1, 2023
2 replies
85 views

Hi there! I am hoping to create a Formula Field in Data Designer that compares the output of ‘Deployment Date’ & ‘First Notification Sent Date? My goal is for the field to return a ‘True’ or ‘1’ value if ‘First Notification Sent Date’ is LESS THAN ‘Deployment Date’, & a ‘False’ or ‘0’ value if ‘First Notification Sent Date’ is GREATER THAN ‘Deployment Date’.

Please let me know if this is possible &/or how you recommend making it happen! Thank you!!!

Best answer by matthew_lind

Hi @Britt_Chy !

In this scenario, a CASE statement sounds like your ticket to success. CASE statements let you write IF-THEN statements. As soon as an IF criteria is met, you can populate a newly created field with the value of another field in your DD task, or you can give it a “hard-coded” value by picking “Custom”

More at this link, with an example:

https://support.gainsight.com/Gainsight_NXT/03Rules_Engine/02Admin_Guides/Customer_Categorization_with_Case_Expression_Formula_field#Configure_Case_Expression

matthew_lindAnswer

VIP ⭐️⭐️⭐️⭐️⭐️

Hi @Britt_Chy !

In this scenario, a CASE statement sounds like your ticket to success. CASE statements let you write IF-THEN statements. As soon as an IF criteria is met, you can populate a newly created field with the value of another field in your DD task, or you can give it a “hard-coded” value by picking “Custom”

Didn't find what you were looking for?

Sign up

Welcome to the Gainsight Community