Hi,

great thanks for your help.

It works perfectly:cool::cool::cool:

Kind regards.

Hi,

great thanks for your help.

It works perfectly:cool::cool::cool:

Kind regards.

Hi,

great thanks for your help.

It works perfectly:cool::cool::cool:

Kind regards.

really, great thanks for your help.

I solved my probleme. I used this code:

WITH

Diffs AS (

SELECT DATEDIFF(hh,demande_help_desk.DateEnvoi,historique_dde.date_modif_dde ) AS DiffHours ,historique_dde.DemandeID

FROM historique_dde INNER JOIN

...

Thanks for your help, but it's not working.:crying:

WITH Diffs AS (

SELECT DATEDIFF(hh,date1, getdate()) AS DiffHours,

FROM historique_dde

), DiffRange AS (

SELECT CASE

WHEN DiffHours < 24 THEN '< 1 Day'

WHEN DiffHours <168...