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?
Best answer by Justin BillsView original
Did you ever find a way to do this without rules engine?
@jessica_owens - I did!!
I made a custom calculated field:
WHEN (field end date) IS NULL THEN gsdateDiff( field start date , gstoday( ) , 'DAY' )
ELSE gsdateDiff( start date , end date , 'DAY' )
The bold/italic would be replaced by whatever your fields are in your instance! :)