Good morning -
I’m trying to build a datediff formula in a calculated field that would find the difference between a start and end date, but if the end date was blank it would use today. Is that possible without leveraging the rules engine?
Solved
Advanced Datediff formula
+3Best answer by Justin Bills
Hi
I made a custom calculated field:
CASE
WHEN (field end date) IS NULL THEN gsdateDiff( field start date , gstoday( ) , 'DAY' )
ELSE gsdateDiff( start date , end date , 'DAY' )
END
The bold/italic would be replaced by whatever your fields are in your instance! :)
+5Did you ever find a way to do this without rules engine?
+3Hi
I made a custom calculated field:
CASE
WHEN (field end date) IS NULL THEN gsdateDiff( field start date , gstoday( ) , 'DAY' )
ELSE gsdateDiff( start date , end date , 'DAY' )
END
The bold/italic would be replaced by whatever your fields are in your instance! :)
+5This is awesome!
The only thing I’ll add to anyone who finds this answer later is that I had to use the “Field Name” (i.e. Custom_Date_Field__gc ) in order for it to work.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.