Help

Date formula override

Topic Labels: Formulas
Solved
Jump to Solution
372 1
cancel
Showing results for 
Search instead for 
Did you mean: 
symone
4 - Data Explorer
4 - Data Explorer

I'm using the formula below to calculate the date difference between the day a position was opened to today (tracking number of days the position is open until filled). Is there a way to override that formula if the Position Status is listed as Filled or to make the formula only run on Positions with the status as Open. I don't want the running count of days once the job is filled, but don't want to lose the data point of the day it was opened.

DATETIME_DIFF(TODAY(),({Open Date}), 'days')
1 Solution

Accepted Solutions
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

This should work:

if({Position Status}="Open",DATETIME_DIFF(TODAY(),({Open Date}), 'days'))

See Solution in Thread

1 Reply 1
Ron_Williams
6 - Interface Innovator
6 - Interface Innovator

This should work:

if({Position Status}="Open",DATETIME_DIFF(TODAY(),({Open Date}), 'days'))