Hi Lucas,
It may be possible through the function "PDMDownTime ".
**PdmDownTime ( slaName, workshift, startDate, endDate ) Calculates the downtime between two dates under the specified SLA and workshift. This function can be used only in the selection list.
See this example discussed in another post of the community, where was used the "PdmToday"
SELECT
cr.group_name,
cr.ref_num,
cr.open_date,
cr.priority_symbol,
cr.status_symbol,
cr.request_area_symbol,
cr.active,
cr.web_url,
(PdmToday() - cr.open_date)/(7*24*3600),
(PdmToday() - cr.open_date)/(24*3600),
(PdmToday() - cr.open_date)/3600,
(case when ((PdmToday() - cr.open_date)/(7*24*3600)) <2 then '1'
when ((PdmToday() - cr.open_date)/(7*24*3600)) >=2 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <3 then '2'
when ((PdmToday() - cr.open_date)/(7*24*3600)) >=3 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <4 then '3'
when ((PdmToday() - cr.open_date)/(7*24*3600)) >=4 AND ((PdmToday() - cr.open_date)/7*24*3600)) <5 then '4'
when ((PdmToday() - cr.open_date)/(7*24*3600)) >=5 AND ((PdmToday() - cr.open_date)/(7*24*3600)) <8 then '5'
when ((PdmToday() - cr.open_date)/(7*24*3600)) >=8 then '6'
ELSE '' end ) as WeeksOpened,
Additional Information
PDM Functions for BusinessObjects Reports
OOTB JasperReports query issue in Studio 6.3
I hope I helped you in some way.
Regards,
Fábio Silva