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:

       

      "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.