Absolute Dates in Set Analysis

[#1]

Hi

I'm trying to do a count of customers based on a particular date:

= count({<

     Period_Date={"$(='31/01/2011')"}

     >} CUSTOMER_ID)

The set analysis above doesn't work - I just get 0, could anyone give me some pointers please?  Any help would be much appreciated

[#2]

Thanks  Joe - I have checked that and it doesn't seem to be the problem.  I think I'm going to have to try and do this another way unfortunately

[#3 · Accepted solution]

I only changed that and go it to work, see attached

[#4]

hmmm I see what you mean - it works in the mock up but not in my main app.  There must be something else causing the problem, or else I've managed to corrupt my main app somehow

Thanks for your help

[#5]

It is probably a comma or bracket out of place it gets me everytime.

Also select one date and then create a list box with this code =Period_Date this will confirm it is definately a date format in the background