Sorry my brain has been sent for dry cleaning. I am performing a calculation on a set of records depending on the creation date, so the fomula is simple, if(creation date >01/04/2002:x*y:0), but the resultant calculation ignores the date and applies to the all the records. What am I missing in the date format.
The creation date field is a date field and the calculation result is a number
Chris