cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

counting no. of days

Hi,

 

I am currently working on a helpdesk app, I want to count the number of days the ticket was submitted until it was resolved excluding weekends. It is already working with below code:

 

RoundDown(DateDiff(D_Submitted.SelectedDate, D_Resolved.SelectedDate, Days) / 7, 0) * 5 +
    Mod(5 + Weekday(D_Resolved.SelectedDate) - Weekday(D_Submitted.SelectedDate), 5)

However, the counting of days should only start when both field "d_submitted" and d_resolved is populated. Currently it counts the number of days even if 1 field is only populated.

 

Hoping someone can help me out. Thanks in advance 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi @Anonymous

You could wrap your formula inside an 'If' statement so that it only calculates the days when d_submitted and d_resolved are not blank. The formula would look like this:

If( IsBlank(D_Submitted.SelectedDate) || IsBlank(D_Resolved.SelectedDate) ,
    Blank(),
    RoundDown(DateDiff(D_Submitted.SelectedDate, D_Resolved.SelectedDate, Days) / 7, 0) * 5 +
         Mod(5 + Weekday(D_Resolved.SelectedDate) - Weekday(D_Submitted.SelectedDate), 5)
)

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Hi @Anonymous

You could wrap your formula inside an 'If' statement so that it only calculates the days when d_submitted and d_resolved are not blank. The formula would look like this:

If( IsBlank(D_Submitted.SelectedDate) || IsBlank(D_Resolved.SelectedDate) ,
    Blank(),
    RoundDown(DateDiff(D_Submitted.SelectedDate, D_Resolved.SelectedDate, Days) / 7, 0) * 5 +
         Mod(5 + Weekday(D_Resolved.SelectedDate) - Weekday(D_Submitted.SelectedDate), 5)
)

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (2,926)