Find next activity date in simple case management ...

[Richardson_Prop]

Hi Brains trust.

I am wanting to show the days a job has been active for, from the date the job was created. All the formulas i’ve been trying aren’t working. Any tips please?

[JonathanBowen]

Hi @Richardson_Property - you can do this:

DATETIME_DIFF(TODAY(), {Created date}, 'days')

[Richardson_Prop · Accepted solution]

JonathanBowen:

DATETIME_DIFF(TODAY(), {Created date}, ‘days’)

Amazing thank you so much that worked.