Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Date differences with null values

Topic Labels: Formulas
Solved
Jump to Solution
2581 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Anabel_Hurtado
4 - Data Explorer
4 - Data Explorer

I need to find the number of days an agent is active. Currently, I have 3 columns “Start Date”, “End Date”, and “Days Active” and my formula in my Days Active column is:

DATETIME_DIFF({End Date},{Start Date},‘days’)

Some agents are still active and do not have an “end date” and I get an error message in the Days Active Column. How do I enhance my formula to replace null values in the End Date column with today’s date?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Anabel_Hurtado! :grinning_face_with_big_eyes: Try this formula:

DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, 'days')

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

Welcome to the community, @Anabel_Hurtado! :grinning_face_with_big_eyes: Try this formula:

DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, 'days')

Thank you! That worked!