# Check IF Record Occurred Within Last 30 Days

Topic Labels: Formulas
Solved
1828 5
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Hi,

We have a base that, amongst other things, generates requests and records when the request is completed. To provide feedback on performance, we measure the number of working days it took to complete the task using:

WORKDAY_DIFF({Request Date},{Time Processed})

We can then use a Summary Block to give an average “headline" of the number of working days taken to complete.

We then have then used the following to report the average during the previous month:

IF(DATETIME_FORMAT({Request Date}, “YYYY-MM”) = DATETIME_FORMAT(DATEADD(NOW(), -1, “month”), “YYYY-MM”),WORKDAY_DIFF({Request Date},{Time Processed}),BLANK())

So here, during Aug, it will give the average for July.

How can we have this a little more “live” by reporting the number of days taken to complete over the past 30 days?

1 Solution

Accepted Solutions
16 - Uranus

Use `DATETIME_DIFF()` to get the amount of time between two dates.

`IF(DATETIME_DIFF(NOW(), {Request Date}, 'days') <= 30, WORKDAY_DIFF({Request Date}, {Time Processed}), BLANK())`

5 Replies 5
16 - Uranus

Use `DATETIME_DIFF()` to get the amount of time between two dates.

`IF(DATETIME_DIFF(NOW(), {Request Date}, 'days') <= 30, WORKDAY_DIFF({Request Date}, {Time Processed}), BLANK())`

6 - Interface Innovator

Perfect @Kamille_Parks - exactly what I needed. Thanks for your help with this.

any idea how to figure all days not just working days (7 day week instead of 5) is it just WEEK?

14 - Jupiter

@Rebecca_Elam
I think you can just replace the `WORKDAY_DIFF` part of @Kamille_Parks’s formula with `DATETIME_DIFF` – if I understand your question correctly.

16 - Uranus

That same formula shows how to use `DATETIME_DIFF()`, which again, calculates the time between two dates.