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
@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! :)
Did you ever find a way to do this without rules engine?