We finally managed to figure it out, mostly on our own. In the end we had somebody from Adobe sitting down with us and confirmed our findings. What cracked it was actually using "View Code" and reading out loud the code. Seems that I am joking, but no - this was actually what did it for us. Enough t...

Thanks, Parvesh, the syntax I used, with INTERVAL and a dynamic offset, was suggested by Adobe Support. Which makes it even more frustrating that is not working. I will press on Adobe support for more clarification. 

HI,The INTERVAL syntax was suggested from Adobe support. I cannot find any reference on the Internat to INTERVAL in connection to PQL, or date_diff (the one you suggested) for that matter. Do you know where to find the complete reference for Adobe PQL, something that will give more details on this v...

Hi,I am trying to create an audience in AEP using API to get profiles that have a certain date attribute before or on a certain date attribute +30 days. I am using this as the API body:;-d '{"name": "LatestCQdt lte LatestDD + 30","profileInstanceId": "AEPSegments","description": "Latest Cheque Redee...

I opened a ticket with Abbott support, no answer yet.

The numbers didn't change after the audience was refreshed. This is in a DEV environment, the data is kind of frozen, so there should be no difference between the profile snapshot and the actual data in the RTCP repository.

Hi, This is estimated profiles. Here is the code view:  There are other criteria, but I ran all those criteria in parallel with the audience and everything matches until I apply that last one:

Hi,I am trying to add some rule in Adobe Experience Platform that in a Query looks like:SELECT count(*) FROM profile_snapshot_export_xxx where <path>.LastChequeRedeemedDate <= dateadd(day,30, <path>.Most_Recent_Drop_Date_DM) -- 477 I set a rule like this in the audience:However, the Query cou...

Thanks. This will work for that particular one example, but lacks flexibility. @supratim320 answer is what I was looking for.

Thanks, @supratim320 , that is exactly what I was looking for!