Check between dates

[#1]

hi everyone, I was trying adding this kind of lines in my script

(CASE (DO31_DATADELIVERY - DO11_DATADOCUMENT)

WHEN (DO31_DATADELIVERY - DO11_DATADOCUMENT)>3 THEN 'In Tempo'

  WHEN (DO31_DATADELIVERY - DO11_DATADOCUMENT)>7 THEN 'Ritardo'

  END)

but I always receive error. But in the chart if I insert the calculation (DO31_DATADELIVERY - DO11_DATADOCUMENT) as an expression, I obtain the number of days between the two dates.

What I'm doing wrong??

[#2]

YOU ROCK @LIOR ABITOL!!!! thank you soooo much!!!!!!!!!

[#3]

Finally! Glad we got it to work!

I made a bad assumption that you were using the LOAD statement, not realizing that you were using SQL.