10 Replies Latest reply: Nov 6, 2017 8:55 AM by Diego Barboza RSS

    Date greater than week end date?

    Mohamed Elafifi

      Hi all,


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





      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.