Count Number of Days

I am having some difficulty figuring out how to enter a formula to count the number of days from a certain date up until today (or whenever the flow is ran). it works fine if there is a start and end date but also need to count the number of days a task has been open for based on a start date only.

E.G Start Task 1st August - No Completed date as yet - How many days has it been open?

Workflow

Date Time

Accepted answers

JamesCharnley

Hi @SimonFEBP

The formula you're going to want to use is DateTimeDiff. If there's no End Date, then you can use DateTimeToday as the second argument. It'd look something like this:

IsNullDateDiff.yxmd

All comments

JamesCharnley

Hi @SimonFEBP

The formula you're going to want to use is DateTimeDiff. If there's no End Date, then you can use DateTimeToday as the second argument. It'd look something like this:

Perfect, Thankyou for the quick reply it worked perfectly/

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703