how to find number of days count

[Anonymous]

Hi,

i have a field status by using this field i know what are status still Inprogress but how many days the IncidentID is crossed the Sla_date.

regards,

Yuvaraj G

[MK_QSL]

Can you provide the output table also?

[avinashelite]

If you want the number of working days between two days then use the networking days ...

networkingdays(Sla_date,Identified_date)

[Anonymous]

i know this method here i need to know what are the incidentID crossed the Sla_date and how many days(count) it crossed. for example: staus=Inprogress, sla_date:9/1/2017 but it still not completed so the 101 incident is crossed 45 days like that i want to know.

[Anonymous]

expecting output table:

[cheenu_janakira]

From the alignment on your table of the "Identified_date", it also looks like your dates are stored in date/time/num format (the ones that are aligned right) and in text (the ones that are aligned left). You might want to ensure that all your values are in a uniform format using some other transformation in your script, e.g. Date#().

Once that is done, you might want another transformation for 'days crossed over SLA' such as "Today() - Sla_date()" or combining with Avinash's suggestion "Networkingdays(Today(), Identified_date)". It all depends on what you want to take as 'end date'.

[rahulpawarb · Accepted solution]

Hello Yuvaraj,

Hope that you are doing well!

Please refer below given sample expression:

//Days Past SLA
=If(Status='Inprogress' AND Today() - Date#(SLA_Date, 'DD/MM/YYYY') > 0,Today() - Date#(SLA_Date, 'DD/MM/YYYY'), '')

Refer attached application.

Regards!

Rahul

[Anonymous]

thanks rahul its working  fyn....

[rahulpawarb]

Cheers,

Rahul