Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Date formula override

Topic Labels: Formulas
Solved
Jump to Solution
784 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'))