Set analysis syntax?

[#1]

I am trying to create a set Analysis for a pivot table to return the previous months Enquiries from our CRM system

Every enquiry has an Openeddate

Below is what I have come up with, with the help of previous cases on here for similar requests. But it is not returning anything for me. Any ideas?

{<OPENEDDATE = {">=$(=monthstart(addmonths(today(),-1)))<$(=monthstart(today()))"}>}

[jvitantonio]

Is OPENDATE a month? or a complete date? Your variable is just returning e number.

You can't compare for example 10/12/2012 with 12

[#3]

Sorry, Openeddate is a date field in the database in the format DD/MM/YYYY

[#4 · Accepted solution]

Whoops

User error

I had other items selected in the document

The syntax for the set was correct all along