Skip to main content

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?

Did you ever find a way to do this without rules engine?

Hi @jessica_owens  -  I did!!

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! :)

This 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.

Reply


Terms & ConditionsCookie settings