• SugarQuery Having Max(datefield) < xxxx-xx-xx

    Hi, I need to create a query which selects contacts which only having cases older then one year. I managed to create a working MySQL query, but how to convert it to a SugarQuery? Anyone any experience with this type of query? MySQL SELECT contacts…