Date greater than week end date?

[Anonymous]

Hi all,

I am having difficult getting a query like this to run, and I could really use some help. What I have is:

"OPEN_DATE",

"CLOSED_DATE",

WeekEnd("OPEN_DATE") AS OPEN_WEEK

What I am trying to get is the count of all OPEN_DATE where the CLOSE_DATE is greater than the OPEN_WEEK. I thought this would be as simple as:

count(CLOSE_DATE > OPEN_WEEK)

But I was sorely mistaken. I've looked into other queries through the forums, but I haven't had much luck at all.

Any help with this query would be much appreciated.

[diego_a_barboza]

Hello Mohamed,

Please check,because the object expression is counting all orders that are opened for matching week on calendar (since Closed date is greater than End week).

Just for you to verify, I am including the expression for closed orders.

// Accumulated Open Escalations

// count(distinct IF(CLOSED_DATE > WEEK_END_DATE , ESCALATION_NUMBER))

// Closed escalations

// count(distinct IF(CLOSED_DATE < WEEK_END_DATE  , ESCALATION_NUMBER))